Calculate due date 1 or 2 years ahead to the first of the followi.
 

Issue date is June 12,2004. Certificate is valid ( 24 months ) to July 01,
2006. How do I create this is XL?

Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?

I modified your's ... does this make sence..seem's to work
=DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1)

"Frank Kabel" wrote:

Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?

Hi
sorry, my fault. Did not read your first post carefully enough. So it should
be always the first day of the next month. Then use:
=DATE(YEAR(B2)+2,MONTH(B2)+1,1)

or
=DATE(YEAR(B2),MONTH(B2)+25,1)

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
I modified your's ... does this make sence..seem's to work
=DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1)

"Frank Kabel" wrote:

Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?

T
Thanks Frank ... Further to this scenario, how would I set up a Current date
warning, 2 months prior to this expiration ( 1 or 2 years ) date, Red Font,
using conditional format?

....Wayne McKillop
Montreal QC, Canada

"Frank Kabel" wrote:

Hi
sorry, my fault. Did not read your first post carefully enough. So it should
be always the first day of the next month. Then use:
=DATE(YEAR(B2)+2,MONTH(B2)+1,1)

or
=DATE(YEAR(B2),MONTH(B2)+25,1)

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
I modified your's ... does this make sence..seem's to work
=DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1)

"Frank Kabel" wrote:

Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?

Hi
have a look at format - conditional format and use a formula such as
=A1<=DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODAY ()))

where A1 stores your calculated expiration date

--
Regards
Frank Kabel
Frankfurt, Germany

Kane wrote:
T
Thanks Frank ... Further to this scenario, how would I set up a
Current date warning, 2 months prior to this expiration ( 1 or 2
years ) date, Red Font, using conditional format?

...Wayne McKillop
Montreal QC, Canada

"Frank Kabel" wrote:

Hi
sorry, my fault. Did not read your first post carefully enough. So
it should be always the first day of the next month. Then use:
=DATE(YEAR(B2)+2,MONTH(B2)+1,1)

or
=DATE(YEAR(B2),MONTH(B2)+25,1)

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
I modified your's ... does this make sence..seem's to work
=DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1)

"Frank Kabel" wrote:

Hi
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Wayne wrote:
Issue date is June 12,2004. Certificate is valid ( 24 months ) to
July 01, 2006. How do I create this is XL?