yourvariable =Worksheetfunction.TEXT(A1;"dddd")

where A1 contains the date value.

Regards,
Stefi

€žGreg Billinge€� ezt Ã*rta:

Hi,

I need to work out what day of the week it is from a date value. I know you
can show it in formatting but i need to set the value of a variable in my
macro to Monday, Tuesday etc.

Any help is really appreciated.

Thanks

Greg