MATCHING DATE TO A WEEKDAY

S

Stuart Carnachan

Is there an easy way to indentify the weekday from a specfic date rather than
go down the lookup route
 
L

LR

Use the text formula ie in cell A2 type =TEXT(A1,"DDDD""). Converts the date
in A1 to the full name of the day. If you only use "DDD" it will abreviate
the day name as Tue instead of Tuesday. Formula also works for Months using
"MMM"
 
R

Roger Govier

Hi Stuart

Format>Cells>Number>Custom mmm will give Mon mmmm will give Monday
Either apply this to your cell with the date (A1), or to another cell
which has the formula =A1
 
Top