Monday 19 September 2011

Weekday of a date in Excel

What day of the week was 15-Aug-1976? Or  26-Jan-2015?

In Excel:
In Cell A2 (or any other cell) input the date as 15-aug-76 or 15/aug/76
In cell B2,input the formula =TEXT(A2,"ddd"). The weekday will be displayed.

Note: If instead of "ddd" , "dddd" is used in the formula, then the date will be displayed as "Sunday". 

No comments:

Post a Comment