Account for third pay period in month, libreoffice calc

[claven123]

I have a budget and I have pay period dates set up in say.... A1 is a set date, 01/13/2017 (first pay period for the year). I then have another cell, A20 with =A1+14 which gives me the next pay date and so forth and so forth along the months across sheets. Works great, well until you get three pay periods in the month. The third pay period is set up with the same grouping of budget stuff, IF needed. That cell, A50 would have the same formula A20+14.

How do I set up that cell, A50 to only do the math if there is a third pay period in it..... THEN if it's used the next cell would have to adjust and use that cell A50 for the source of the next formula.

Does this make sense?

A1 is a date 01/13/2017
A20 is =A1+14
A50 is =IF(A20+14=SAME MONTH as A1, A20+14)

No idea how to code the "SAME MONTH as A1"


Thanks,

D

 

[SyedUsman]

Re: How to account for third pay period in month, libreoffice calc

Pls try this

=IF(MONTH(A20+14)=MONTH(A1), A20+14,"2nd Condition")

 

[claven123]

Re: How to account for third pay period in month, libreoffice calc

I can't see the rest of your code.... this is what I see.


=IF(MONTH(A20+14)=MONTH(A1), A20+14,"2nd Condition")


I'm not sure what the 2nd condition means...

Should I post this to a specific libreoffice forum?


Thanks

D

 

[SyedUsman]

Re: How to account for third pay period in month, libreoffice calc

A50 is =IF(A20+14=SAME MONTH as A1, A20+14)

Second condition is whatever you want to put it . you did not mention what you want if the argument is false

 

[claven123]

Re: How to account for third pay period in month, libreoffice calc

Yes, yes... forgot about that, for some reason I thought that was some other thing.

This worked great, thanks!!

=IF(MONTH(AY23+14)=MONTH(AY11), AY23+14,"-")

Dennis