Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional if a date is valid
I have the following formula already working:
=P19-(IF(AND(P4:P18)=7,0.5,0)*P22)-IF(P4<=5,P4,P4-0.5)-IF(P14<=5,P14,P14-0.5) currently I have to manually correct p4 and p14 to match if the row where 4 and 14 are Sundays. I.e. If during this payroll, Sunday falls on A5 I should manually change p4 to p5. How could I do this automatically, if my dates are in Column A? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional if a date is valid
Hi,
What does A5 have to do with your formula? There are no refernces in the formula to A5, in fact your formula doesn't refer to any cell in column A. So what do dates in column A have to do with it? -- Thanks, Shane Devenshire "Connie" wrote: I have the following formula already working: =P19-(IF(AND(P4:P18)=7,0.5,0)*P22)-IF(P4<=5,P4,P4-0.5)-IF(P14<=5,P14,P14-0.5) currently I have to manually correct p4 and p14 to match if the row where 4 and 14 are Sundays. I.e. If during this payroll, Sunday falls on A5 I should manually change p4 to p5. How could I do this automatically, if my dates are in Column A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Conditional formatting to highlight the lowest valid value | Excel Worksheet Functions | |||
Retain Conditional Format When Condition Is No Longer Valid | Excel Discussion (Misc queries) | |||
How to valid the date with given condition? | Excel Discussion (Misc queries) | |||
How to check valid Date value? | Excel Worksheet Functions |