Log In
Register
Home
How to tell excel that an entry is a specific month?
Alex Meins
Member
Members
Forum Posts: 7
Member Since:
May 25, 2021
May 25, 2021
Offline1
February 28, 2022 - 7:46 pm
Hello,
i just created a smart table and used colums, one for month and one for year.
Problem is, that now the pivot table is not recognizing the month entries as "dates" as they are words and excel doesn't know which date that is.
What can i do, to keep the convenient level data input for my key users as they dont want to type in a specific date but just the month and the year per line, but also use timeline slicers for my dashboard.
Would it work with a helper column?
Thank you very much,
LxMe
See Answer
Velouria
London or thereabouts
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 689
Member Since:
November 1, 2018
November 1, 2018
Offline2
March 1, 2022 - 12:41 am
Yes, you could add a helper column using DATEVALUE and creating a date string that your regional settings can work with - for example (zB):
=DATEVALUE("1 "&[@Monat]&" "&[@Jahr])
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Philip Treacy, Peter Venkatrao, QSolutions Group
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6546
Posts: 28655
Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —