Calculating Accrued Vacation Pay

[Chas123]

abcd123456

[easyexcelanswers]

None of your dates would qualify for vacation yet so I change the formula to have vacation available after two months, you can just change the 2 to a six for your needs

=IF((MONTH(TODAY())-MONTH(H4))>2, (MONTH(TODAY())-MONTH(H4))*$C$2, 0)

I also created a formula to calculate when they would be the six months are up

=EDATE(H4,6)

[easyexcelanswers]

I thought that I sound send you the sheet backfixed of Ascendium Vacation Tracking (1).xlsx