View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How Do I increase a date by 90 days?

A1 has the inputted date.

B1 has this formula =A1 + 90

Format both to Date.

To fancy it up a bit you could have B1 turn red when the 90 days was up.

Select B1 and FormatConditional FormattingFormula is:

=B1(A1 + 89)

On day 90 B1 will turn red to alert you.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 14:51:02 -0700, Rockcop222
wrote:

Hello...

I have to keep track of DVD's out of Police patrol cars...state law says we
have to keep the data for 90 days. I want to be able to input a date into a
cell, and then have it automatically add 90 days to that date and put the new
date in the next cell over to the right. This new date will tell me when the
DVD can be erased.

Can this be done?

John