• 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

vletm

Excel Ninja
Shabbo
Convert?
Could You format cell Your dates with DD-MM-YYYY.
If convert ... then those won't be dates anymore (texts).
 

vletm

Excel Ninja
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?
 
Top