update data alert using = today()

  • Thread starter Thread starter Elvira Stewart
  • Start date Start date
E

Elvira Stewart

Hi i am looking to create a date function that alerts me to when 6
months has passed and tells me I need to update my data.
 
ok so far i created the date to compare it to by doing =TODAY()-
DATEVALUE("6/1/2009"), so I can have a count down to six months from
now---so is there an if function i can do? eg: if this cell =0 day
count down inform me that I need to update
Thanks!
 
Since you want a countdown, you'll want to subtract today's date from that date
that is 6 months in the future.

If A1 contains the start date, then you could have the date 6 months from there
in A2:

=date(year(a1),month(a1)+6,day(a1))
(format it as a date)

Then in A3, you could have the countdown formula:
=A2-today()
(and format it as General (not a date))

You could elimnate those helper cells as much as you wanted:

A3 could contain:
=date(year(a1),month(a1)+6,day(a1)) - today()

or even embed the date into the formula and drop the reference to A1:
=date(2009,12,25) - today()
(where Dec 25, 2009 is that date in the future.)
 
Back
Top