Need date to appear 90 days later than initial date entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using formula to find out a Date 90 prior to a particular date 2
How to add 30, 60 and 90 days to date and calculate deepening disc 5
Conditional Format Based on Date 3
Finding a Date 90 days previous to present date 1
Conditional Formatting 3
Excel TRYING TO CREATE A FORMULA in excel PLEASE HELP!!! 1
Conditional Format based on date 2
using dates for lookup 2

Back
Top