Wednesday 6 May 2015

Fetch day/date/month/year from Date

Month - =TEXT(A1,"mm")


year - =TEXT(A1,"yyyy")

Day - =TEXT(A1,"dddd")


Date - =TEXT(A1,"d")

No comments:

Post a Comment