Re-occuring Inspection Dates

B

Belarny Mic

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?
 
B

Bill Kuunders

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...
 
B

Biff

Hi!

Another way that doesn't require the ATP:

Date in A1 = 1 Jan 05

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

Biff
 
Top