• 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.

Dates

Shabbo

Member
Dear Sir,
I wanted to convert my data to dates as (DD-MM-YYYY).
Please help as its not getting converted.
 

Attachments

  • dates.xlsx
    16.5 KB · Views: 5
Shabbo
Convert?
Could You format cell Your dates with DD-MM-YYYY.
If convert ... then those won't be dates anymore (texts).
 
Shabbo
Convert?
Could You format cell Your dates with DD-MM-YYYY.
If convert ... then those won't be dates anymore (texts).
Dear Sir,
Thanks for your reply.
I wanted to get result like highlighted in yellow but it’s not coming.
 

Attachments

  • dates.xlsx
    25.6 KB · Views: 1
Shabbo
I wanted to convert my data to dates as (DD-MM-YYYY).
... above seems to work ...
... and now ...
I wanted to get result like highlighted in yellow but it’s not coming.
... do You would like to get only day - out from date?
... if so ... then eg for cell C2 =day(a2)
Excel seems to work well - You just need to tell to Excel - what do You would like to get?
 
Back
Top