Tracking dates in Excel
 

What would be the formula to do the following in Excel (2003)? Want to be
able to enter a series of different start dates and then with a formula have
Excel calculate a corresponding event date 3 months later, 6 months later, 9
months later, and 12 months later. It would be acceptable to have the system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel

Tracking dates in Excel
 

Try this:

A2 = some date

Enter this formula in B2 and copy across to E2:

=DATE(YEAR($A2), MONTH($A2)+COLUMNS($B2:B2)*3,DAY($A2))

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
What would be the formula to do the following in Excel (2003)? Want to be
able to enter a series of different start dates and then with a formula
have
Excel calculate a corresponding event date 3 months later, 6 months later,
9
months later, and 12 months later. It would be acceptable to have the
system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel

Tracking dates in Excel
 

Or, more simply:

Entered in B2 and copied across:

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


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

A2 = some date

Enter this formula in B2 and copy across to E2:

=DATE(YEAR($A2), MONTH($A2)+COLUMNS($B2:B2)*3,DAY($A2))

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
What would be the formula to do the following in Excel (2003)? Want to be
able to enter a series of different start dates and then with a formula
have
Excel calculate a corresponding event date 3 months later, 6 months
later, 9
months later, and 12 months later. It would be acceptable to have the
system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel

Tracking dates in Excel
 

I'll try that . Thank you.
--
Dee, new to Excel


"T. Valko" wrote:

Or, more simply:

Entered in B2 and copied across:

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


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

A2 = some date

Enter this formula in B2 and copy across to E2:

=DATE(YEAR($A2), MONTH($A2)+COLUMNS($B2:B2)*3,DAY($A2))

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
What would be the formula to do the following in Excel (2003)? Want to be
able to enter a series of different start dates and then with a formula
have
Excel calculate a corresponding event date 3 months later, 6 months
later, 9
months later, and 12 months later. It would be acceptable to have the
system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel

Tracking dates in Excel
 

PERFECT! Thank you so much.
--
Dee, new to Excel


"T. Valko" wrote:

Or, more simply:

Entered in B2 and copied across:

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


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

A2 = some date

Enter this formula in B2 and copy across to E2:

=DATE(YEAR($A2), MONTH($A2)+COLUMNS($B2:B2)*3,DAY($A2))

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
What would be the formula to do the following in Excel (2003)? Want to be
able to enter a series of different start dates and then with a formula
have
Excel calculate a corresponding event date 3 months later, 6 months
later, 9
months later, and 12 months later. It would be acceptable to have the
system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel

Tracking dates in Excel
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
PERFECT! Thank you so much.
--
Dee, new to Excel


"T. Valko" wrote:

Or, more simply:

Entered in B2 and copied across:

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


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

A2 = some date

Enter this formula in B2 and copy across to E2:

=DATE(YEAR($A2), MONTH($A2)+COLUMNS($B2:B2)*3,DAY($A2))

--
Biff
Microsoft Excel MVP


"Dee" wrote in message
...
What would be the formula to do the following in Excel (2003)? Want to
be
able to enter a series of different start dates and then with a
formula
have
Excel calculate a corresponding event date 3 months later, 6 months
later, 9
months later, and 12 months later. It would be acceptable to have the
system
show 60 days later rather than 3 months.

THANK YOU!

--
Dee, new to Excel