Need date to appear 90 days later than initial date entered

B

Becky

I want to input a date into column a and have it appear 90 days later in
column b in order to track due dates, etc.
 
S

Stefi

Insert =A1 in B1 and fill down as necessary!
Select column B, Format/Conditional formatting, select Formula, enter in
Condition =A1+90>TODAY(), Click Format, in Font tab select Color and set it
white!

Regards,
Stefi



„Becky†ezt írta:
 
A

Anne Troy

By the way, Becky. Perhaps you should consider just using conditional
formatting? You can set column A's date to have a red font or red fill when
it's 90 days or older. :)
************
Anne Troy
www.OfficeArticles.com
 
D

dominicb

Good afternoon Becky

Lets assume that your first used cell in column A is A7. A date wil
be in A7, in B7 put this formula:

=IF(NOW()-A7>90,A7,"")

Cell B7 will remain empty until the date in A7 is 90 days old, and the
the date will appear in B7.

HTH

Dominic
 
Top