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