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

have you tried looking in the help index for WEEKDAY

--
Don Guillett
SalesAid Software

<Stuart Carnachan wrote in message
...
Is there an easy way to indentify the weekday from a specfic date rather
than
go down the lookup route
--
Stuart

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"



"Stuart Carnachan" wrote:

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

Hi Stuart

FormatCellsNumberCustom 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
--
Regards

Roger Govier


<Stuart Carnachan wrote in message
...
Is there an easy way to indentify the weekday from a specfic date
rather than
go down the lookup route
--
Stuart