Hi I am new and apologize if I’m in the wrong forum or if I’m not making sense.

I am trying to make a spreadsheet that will forecast how many vacation days a person will accrue on each paycheck, which happens on the 15th and last day of each month.

Where cell A1 will be today’s date, I would like the column underneath to display the next payday, and all following for say one year. I had previously searched and found a formula that will give me the next 15th of the month but didn’t realize that this will only work if the date is earlier than the 15th.

So if my data starts in cell A2, this is the formula I have: =DATE(YEAR(A1),MONTH(A1),IF(DAY(A1)=15,0,15))
And then in cell A3 I have: =EOMONTH(A2,1)
A4: =DATE(YEAR(A3),MONTH(A3),IF(DAY(A3)=15,0,15))
A5: =EOMONTH(A1,2)

And so on…

So if A1 is June 20th, how do I get the next cell to display June 30th AND be able to display July 15th IF the user puts in July 5th the next time?

Thanks.