Day of the week

[mike]

Hi,

How can I program a formula depending on the day of the
week?

I have used =NOW() and =today() and neither seem to come
back with the day of the week only. I need something
that simply comes back with the day of the week.

To be more clear, I need to use different formulas for a
cell based on the day of the week.

eg = IF(A1="Friday",A5+A6,if(A1="Thursday",B5+B6,C5+C6))


thanks,
mike

 

[Domenic]

=TEXT(TODAY(),"dddd")

Hope this helps!

 

[Guest]

Great. Thank you very much!

-----Original Message-----
=TEXT(TODAY(),"dddd")

Hope this helps!


.

 

[Ron Rosenfeld]

IF(A1="Friday",A5+A6,if(A1="Thursday",B5+B6,C5+C6))

=IF(WEEKDAY(A1)=6,A5+A6,IF(WEEKDAY(A1)=5,B5+B6,C5+C6))


--ron