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.
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.
Good afternoon Becky
Lets assume that your first used cell in column A is A7. A date will 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 then the date will appear in B7.
HTH
DominicB
LOL. I think I said 30. I meant =A1+90
************
Anne Troy
www.OfficeArticles.com
"Becky" <[email protected]> wrote in message
news:[email protected]...
>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.
=A1+30 (format as dates)
************
Anne Troy
www.OfficeArticles.com
"Becky" <[email protected]> wrote in message
news:[email protected]...
>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.
=IF(A1+90=TODAY(),A1,"")
perhaps?
--
HTH
Bob Phillips
"Becky" <[email protected]> wrote in message
news:[email protected]...
> 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:
> 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.
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
"Becky" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks