have the following attached simple(ish) one sheet spreadsheet but just one thing i would like to ask
the column marked end date has the date in it, is there a formula or function i can add so when the date has passed it adds a whole 12 months to year so 07/03/2018 would become 07/03/2019
enter this in cell C4 in a new Column C and fill down.
=IF(TODAY()-B4>0,EDATE(B4,CEILING((TODAY()-B4)/365.25,1)*12),B4)
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
or maybe something like that below in some additional column (but I do not know if this will take into account leap years as above) ?
=IF(TODAY()>B4,EDATE(B4,12),"Not yet")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks