I have a tool that users need to enter date information into. I have two challenges
1. They user is not allowed to enter the day, only the month and year. I realize I could format the end result as month and year only (in custom formatting), but am unsure how to manage the input as month and year only.
2. The entry needs to stay in a (numeric) format that a COUNT function can be used to calculate the number of entries.
Thoughts?
Maybe these two formulas will help you out: = MONTH(DateValue) and = YEAR(DateValue)
So if you want a string like 201607 then Year(DateValue) & Month(DateValue) should do it for you.
The following will also work: TEXT(DateValue,"yyyymm")
Last edited by dflak; 07-12-2016 at 03:05 PM. Reason: Second thought
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks