@Saqib Husain, Syed
Shouldn't "TODAY()" actually be referencing the cells within column A?
(Unless I am misunderstanding the question, then I apologize for jumping in.)
=IF(WEEKDAY(A12,2)<5,Mon - Thu Value Goes Here,Fri - Sun Value Goes Here)
Geekamo, spot-on.
Enter this formula in I12
=if(WEEKDAY($A12,2)<5,Mon-Thu value,Fri-Sun value)
You can copy it from here and paste it but remember to insert the correct values.
Copy the formula from I12 to all cells from J12 to L12 and then from N12 to O12
Now change the values in each of these cells to the appropriate value.
Now select J12 to L12 and press ctrl-c
Select J12 to J100 (or whichever your last row is) press ctrl-v
Do the same copy-paste for N12 to O12
@Thomas Stockbruegger,
You would place the formula into each of the columns you reference in your OP.
I12 = IF(WEEKDAY(A12,2)<5,7,7)
J12 = IF(WEEKDAY(A12,2)<5,0,0)
K12 = IF(WEEKDAY(A12,2)<5,15,12)
L12 = IF(WEEKDAY(A12,2)<5,30,0)
N12 = IF(WEEKDAY(A12,2)<5,0.75,0.25)
O12 = IF(WEEKDAY(A12,2)<5,7.75,4.75)
and then copied down...
(Keep in mind, if column A contains Saturday/Sunday dates - they will share the same value as Friday.)
Additionally, the TRUE/FALSE values IN your formula should reference a decimal (not a comma).
@Saqib Husain, Syed - please correct me if I am wrong. I am certainly no expert. :-)
Geekamo, you are right. All commas and periods should be interchanged in our formulas.
@ Thomas Stockbruegger
Can you attach your workbook - with any/all private information removed?
Try
=if(WEEKDAY($A12.2)<5.7.7)
Fabulous, glad you got it working!
Hope to see more of you. Best regards from Pakistan.
You can use a formula like this
=if(WEEKDAY(TODAY(),2)<5,Mon-Thu value,Fri-Sun value)
To override, simply type in the value so that there is no formula in that cell.