J
jwfullerton
I have the date in cell B7 (shows 1 for 1 Sept 08). In cell B6 I have the
corresponding day of the week (formula in B6 is =B7, formatted to show ddd).
B C D
6 Mon Tue Wed
7 1 2 3
8 450 450 450
In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday
or Sunday, then return " ", otherwise return 7.5*60.
Can anyone help me with this?
Thanks!
corresponding day of the week (formula in B6 is =B7, formatted to show ddd).
B C D
6 Mon Tue Wed
7 1 2 3
8 450 450 450
In cell B8, I want to input a formula to evaluate B6. If B6 equals Saturday
or Sunday, then return " ", otherwise return 7.5*60.
Can anyone help me with this?
Thanks!