How to extract day from date in excel?

Asked By:
2 answer(s)
Answer # 1 #

To get weekday name, use =TEXT(A1,"dddd").

[4 Month]
(2)
Answer # 2 #

Use formula: =DAY(A1) where A1 contains the date. This returns the day number.

[4 Month]
(0)

More Questions