• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Simple date format

Thank you Chihiro, it did exactly what I was asking; however, it does not work in my formula. So, I am attaching my calendar sheet to see how else, or what else can be done to solve this problem. . .
 

Attachments

  • Format date.xlsm
    13.8 KB · Views: 4
There's two ways to accomplish.

1. Also apply same custom format to M2. (Recommended as retaining underlying Date/Time value is useful in subsequent analysis)

2. Use Text function. =TEXT(H2,"mmddyyyy")

Not sure why you are breaking it apart and re-constructing in Q2.

I'd do it differently. See attached for your table replicated but retaining DOB/Date of birth as date value.
 

Attachments

  • Format date.xlsm
    15.7 KB · Views: 3
Back
Top