Conditional if a date is valid

C

Connie

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?
 
S

Shane Devenshire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Cell Formula 9
Creating Pricelists from product list in Excel 2003 2
Conditional formating question 3
Generate Pricelist from Product list in Excel 2003 0
TODAY() issues 6
Excel Dates 3
copy row when matching colums found 3
What Code and where do I put it to Nest Loop 1

Top