Re-occuring Inspection Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Hi!

Another way that doesn't require the ATP:

Date in A1 = 1 Jan 05

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 make 1 date cell automatically change another date cell 3
2 dimensional date sort 1
Date to Day 2
Mortgage amortization schedule with Interval Extra Payments 3
Month (MMM) from date (dd/mmm/yy) 1
date format and the RIGHT function 1
Allocate Value Across Monthly Periods 1
Date difference 7

Back
Top