in excel have:
- (h10) constant -----------17/04/2015 --------been updating month manually.
- (h11) day counter -------28 -----------------=day(today())
- (h13) last update -------17/04/2015 ------=if(h11=17, edate(h13,1), h10)
i can h13 update new month adding 1 month once counter moves off 17 reverts old date h10.
is there way in excel keep 17th constant , update month , year every 17th?
if want cell automatically show next 17th of month (i.e. next 1 after today) can use stand alone formula
=eomonth(today()-16,0)+17
format required date format
that display 17-may-2015 until reach 17th may, @ point change 17-june-2015, , keep updating every month
