Cell Value Based on a Day of the week....

[debug]

Hi Guys

I have a column A with dates eg: 2012/04/02 and I want to add a value into column B 120 but on a Saturday it must return value 80. So Monday to Friday must return 120 and Saturdays must return 80.

 

[VoG]

Try

=IF(WEEKDAY(A1)=7,80,120)

 

[debug]

Thank you works perfectly.