Thank You FDibbins, yes i want to repeat the expire date every 12 month.
Thank you nflsales & kvsrinivasamurthy , Expire date is exactly what i want.
more advance, how to tweak the formula :
If the current date exceeded expire date , then expire date + 12 month, if not exceeded then use expire date
=IF(I3>DATE(YEAR(TODAY()),MONTH(H3)+3,1),DATE(YEAR(TODAY()+1),MONTH(H3)+3,1),DATE(YEAR(TODAY()),MONTH(H3)+3,1))
is it correct?
example for expire date Sep 2015.
Result will be : IF current date ( 26 Nov 2015) > Sep 2015, then expire date will be Sep 2016
for expire date Dec 2015, it still Dec 2015, as 26 Nov 2015 not exceeded Dec 2015.
Bookmarks