Tracking dates in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dee - 07 Sep 2007 05:26 GMT

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!

Signature

Dee, new to Excel

Reply to this Message

T. Valko - 07 Sep 2007 05:44 GMT

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))

Signature

Biff
Microsoft Excel MVP

> 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
[quoted text clipped - 6 lines]
>
> THANK YOU!

Reply to this Message

T. Valko - 07 Sep 2007 05:54 GMT

Or, more simply:

Entered in B2 and copied across:

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

Signature

Biff
Microsoft Excel MVP

> Try this:
>
[quoted text clipped - 14 lines]
>>
>> THANK YOU!

Reply to this Message

Dee - 07 Sep 2007 07:06 GMT

I'll try that . Thank you.

Signature

Dee, new to Excel

> Or, more simply:
>
[quoted text clipped - 20 lines]
> >>
> >> THANK YOU!