Forum Discussion
Date related IF query
This is a bit fiddly but I'm hoping someone can help. I want to work out the date someone is eligible for promotion, relating to the date they joined the company. The eligibility date is joining ...
I hope I understood everything correctly, so here is my proposal:
in C2: =DATE(YEAR(B2)+3,MONTH(B2)DAY(B2))
in D2: =IF(MONTH(C2)>=6,DATE(YEAR(C2)+1,6,1);DATE(YEAR(C2),6,1))
And then just copy the formulas down.
Kind regards,
Martin
Thank you so much!! This has worked 🙂