Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 8th 06, 10:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default How Do I increase a date by 90 days?

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

  #2   Report Post  
Old August 8th 06, 11:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default How Do I increase a date by 90 days?


Hi,

Try

A1 = your Date
B1 = Your date + 90

=DATE(YEAR(A1), MONTH(A1)+3, DAY(A1))


http://www.excelforum.com/showthread...14#post1679714

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569662

  #3   Report Post  
Old August 8th 06, 11:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
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


  #4   Report Post  
Old August 8th 06, 11:18 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,688
Default How Do I increase a date by 90 days?

Hi!

If I give you the answer will I get a "break" on my next speeding ticket?

Just add 90 to the date.....

A1 = 8/8/2006
B1 = =A1+90

You can get "fancy" and use conditional formatting to highlight cells when
their expiration date arrives. That will make it easier to see which DVD's
need to be erased.

For example, using the above, B1 would return 11/6/2006. You can set cell B1
to change color on 11/6/2206 thus getting your attention.

To do that:

Select cell B1
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the little box to the right:

=AND(ISNUMBER(B1),TODAY()=B1)

Click the Format button
Select a different font color or a different cell fill color (or both!)
OK out

Biff

"Rockcop222" wrote in message
...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Number of days from one date to another Renz09 Excel Discussion (Misc queries) 2 May 3rd 06 10:18 AM
I want any date 90 days or older from current date change color Big Abalone Excel Worksheet Functions 5 April 23rd 06 05:01 AM
formula to calculate future date from date in cell plus days Chicesq Excel Worksheet Functions 8 November 3rd 05 12:25 PM
set a date in columns 7 days apart Squirel Eater Excel Worksheet Functions 8 June 26th 05 02:00 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017