Re-occuring Inspection Dates

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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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?

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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
news:[email protected]...
>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?