Re-occuring Inspection Dates
 

I need to be able to enter a date in one cell and automatically have a date
inserted in another cell at a specific interval. (EX: I input 1 Jan 05 in one
cell and 1 Jul 05 will automatically appear in another cell (a 6 month
interval). I have Microsoft Office 2002 operating with Microsoft XP
Proffesional. Any suggestion?

if today's date is in A2
enter in B2

=EDATE(A2,6)
format the cells as date

you will need to have installed the addin "analysis toolpak"
go to tools<add-ins...
--
Greetings from New Zealand
Bill K

"Belarny Mic" <Belarny wrote in message
...
I need to be able to enter a date in one cell and automatically have a date
inserted in another cell at a specific interval. (EX: I input 1 Jan 05 in
one
cell and 1 Jul 05 will automatically appear in another cell (a 6 month
interval). I have Microsoft Office 2002 operating with Microsoft XP
Proffesional. Any suggestion?

Hi!

Another way that doesn't require the ATP:

Date in A1 = 1 Jan 05

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

Biff

"Belarny Mic" <Belarny wrote in message
...
I need to be able to enter a date in one cell and automatically have a date
inserted in another cell at a specific interval. (EX: I input 1 Jan 05 in
one
cell and 1 Jul 05 will automatically appear in another cell (a 6 month
interval). I have Microsoft Office 2002 operating with Microsoft XP
Proffesional. Any suggestion?