• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 95
  • Last Modified:

Excel Formulas

Sample workbook attached. Please review Sheet (Post) cell B2:B29. I don't understand why it wont read the proper MONTH() value. Can someone please help explain this? I am referencing the date from the Sheet (In) which must stay this way because it is being used as a bigger part of the picture than is visible here.
Ryan Rood
Ryan Rood
2 Solutions
Martin LissOlder than dirtCommented:
Just use =Month(A2)
Ryan RoodAuthor Commented:
It would be nice if life was that simple. I need to provide a digit month code ... 01, 02, 03, etc.
Wayne Taylor (webtubbs)Commented:
Or, if you want it to remain formatted as "MM", use this...


Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Try like this:
The problem is in the Text function. Replace "MM" with "00".
Ryan RoodAuthor Commented:
I was sure I tried this before but clearly not. I was using TEXT(DATE) or DATE(TEXT) which was not working. This has fixed my issue!

Thank you for the assistance.
I'm glad i was able to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now