Days from Dates

[BobWhiddon]

Hi, does anyone know a formula or vlookup to return the day of the week (Mon, Tue, etc) from a date? Thanks, Bob

[daddylonglegs]

If you have a date in A1 try this formula in B1

=TEXT(A1,"dddd")

That'll give the full day like "Monday" - for "Mon" use just 3 ds, i.e. "ddd"

[Mick2011]

Try this in the cell you want the day to appear..

=IF(ISBLANK(H5),"",WEEKDAY(H5,1))

[arthurbr]

Mick

The OP asked to return the day as a string Mon Tue, etc.. The WEEKDAY function returns a number