• 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.
SampleWorkbook.xlsx
0
Ryan Rood
Asked:
Ryan Rood
2 Solutions
 
Martin LissOlder than dirtCommented:
Just use =Month(A2)
0
 
Ryan RoodAuthor Commented:
It would be nice if life was that simple. I need to provide a digit month code ... 01, 02, 03, etc.
0
 
Wayne Taylor (webtubbs)Commented:
Or, if you want it to remain formatted as "MM", use this...

    =TEXT(A2,"MM")

Wayne
0
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.

 
Wilder1626Commented:
Hi

Try like this:
=TEXT(A2,"mm")
0
 
akbCommented:
The problem is in the Text function. Replace "MM" with "00".
0
 
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.
0
 
Wilder1626Commented:
I'm glad i was able to help.
0
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