| 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? |
| 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 | |||
Threaded Mode
