formula for paydates - calculating maternity pay

[pendle666]

Hello

I'm not sure if this can be done via a formula or if VB is required.

I have some maternity pay calculations and I need the paydate cells to be 25th of whatever the month is.

For example:

Employee goes on mat leave on 23 March, so the paydate cell needs to be 25 March, if they go on mat leave on 1 April, pay date is 25 April.

I have used EDATE to move the month on: =EDATE(E15,0) but E15 is 23 March, so it gives me 23 March, if I used =EDATE(E15,1), it gives me 23 April.

But I need 25th and I'm not sure where to start looking.

Any help gratefully received.

thank you!

thank you for helping

____________
Pendle

 

[strongm]

=EOMONTH(E15-25,0)+25

 

[Scott24x7]

Can you just use Day to check if it's the 25th of the month?

=IF(DAY(A1)=25, "Yes", "No")

That's In Cell. You may need 2 or 3 cells to get interim results for other calculations, but DAY() should tell you if it's the 25th or not?


Best Regards,
Scott
MSc ISM, MIET, MASHRAE, CDCAP, CDCP, CDCS, CDCE, CTDC, CTIA, ATS, ATD

"I try to be nice, but sometimes my mouth doesn't cooperate.

 

[SkipVought]

Even simpler...

=DAY(A1)=25

...will return True or False

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[strongm]

Yeah, I'd assumed the OP wanted to calculate the pay date cell, rather than test a cell to see if it was the pay date

 

[pendle666]

Thank you for the replies.

I've used the EOMONTH formula as that gives me the actual pay date which is what I'm needing.

I've then used 1, 2,3 etc down the column to move the months on.



thank you for helping

____________
Pendle