Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 93
  • 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 LissRetired ProgrammerCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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