| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
|
#6
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
| Calculate age as of a given date | Excel Discussion (Misc queries) | |||
| Calculate age as of a date certain | Excel Discussion (Misc queries) | |||
Linear Mode
