How to calculate expiry date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Justina - 21 Apr 2007 07:16 GMT

How do i calculate an expiry date with Date of policy eg: 4 Apr and insurance
period, ie: 60 days, with excel 2000, i am a new user. Thanks in advanced im
stuck.

Reply to this Message

Niek Otten - 21 Apr 2007 10:10 GMT

With the start date in A1:
=A1+60

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do i calculate an expiry date with Date of policy eg: 4 Apr and insurance
| period, ie: 60 days, with excel 2000, i am a new user. Thanks in advanced im
| stuck.

Reply to this Message

Stan Brown - 21 Apr 2007 13:05 GMT

Fri, 20 Apr 2007 23:16:01 -0700 from Justina
<Justina@discussions.microsoft.com>:

> How do i calculate an expiry date with Date of policy eg: 4 Apr and insurance
> period, ie: 60 days, with excel 2000, i am a new user. Thanks in advanced im
> stuck.

If the policy date is in cell A1, this formula does it:
=A1+60

If the policy date is in cell A1 and the term is in A2, this formula
does it:
=A1+A2

(And I don't think "ie" or even "i.e." means what you think it
means.)

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message

MartinW - 22 Apr 2007 09:47 GMT

> (And I don't think "ie" or even "i.e." means what you think it
> means.)

A very common misuse. I was actually taught at school that i.e.
meant 'for instance'. It wasn't till well after I left school that I
discovered the true meaning to be 'that is' or 'that is to say'.

Regards
Martin

Reply to this Message

Justina - 22 Apr 2007 14:04 GMT

Thankyou all, ya learn something everyday, i love it!!!

> > (And I don't think "ie" or even "i.e." means what you think it
> > means.)
[quoted text clipped - 5 lines]
> Regards
> Martin

Reply to this Message