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: 842
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: Alan Sidman
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1945
SunnyKow: 1432
Anders Sehlstedt: 959
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jennifer Hull
kris king
Hasanul Karim
Terrie s
Jack Ennis
Gary Day
Michael Wiliams
Jim Collier
Allan Chan
Rik Lelliott
Forum Stats:
Groups: 3
Forums: 25
Topics: 7159
Posts: 31414
Member Stats:
Guest Posters: 50
Members: 34674
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —