formula to put today day of the week in a cell

[chriscim]

hi i know how to put todays date in a cell like = today() -
but how do u put the day of the week like
to put thursday in a cell automatically
each day

thanks
chris

 

[Mudface]

Try: -

=TEXT(NOW(),"dddd")

Hope that's what you meant .

 

[sen_edp]

format the cell with the date
as


dddd

 

[chriscim]

thank you
just what i needed
thanks