| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add 24mo to a date
Hello,
What formula would I use to add 24 months to a date in A1? Thanks Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
Hi,
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) Mike "Jim" wrote: Hello, What formula would I use to add 24 months to a date in A1? Thanks Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
"Jim" wrote:
What formula would I use to add 24 months to a date in A1? That depends on what you expect for 2/29/2008: 2/28/2010 or 3/1/2010? =EDATE(A1,24) will result in 2/28/2010. If you get a #NAME error, read the help page for EDATE. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
This is perfect. I have two more questions if oyu have a moment.
How do I write this formula to show (blank) if A1 is empty? And Can you help me with a formula that will poulate an X if the date in A1 is 3mo or less. X showing in B1. Thanks Jim "Mike H" wrote: Hi, =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) Mike "Jim" wrote: Hello, What formula would I use to add 24 months to a date in A1? Thanks Jim |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
=IF(A1="","",DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jim" wrote: This is perfect. I have two more questions if oyu have a moment. How do I write this formula to show (blank) if A1 is empty? And Can you help me with a formula that will poulate an X if the date in A1 is 3mo or less. X showing in B1. Thanks Jim "Mike H" wrote: Hi, =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) Mike "Jim" wrote: Hello, What formula would I use to add 24 months to a date in A1? Thanks Jim |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
Luke has answered the part about the cell being blank. You will have to
clarify what you mean by Can you help me with a formula that will poulate an X if the date in A1 is 3mo or less. X showing in B1 3 months or less then what? Mike "Jim" wrote: This is perfect. I have two more questions if oyu have a moment. How do I write this formula to show (blank) if A1 is empty? And Can you help me with a formula that will poulate an X if the date in A1 is 3mo or less. X showing in B1. Thanks Jim "Mike H" wrote: Hi, =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) Mike "Jim" wrote: Hello, What formula would I use to add 24 months to a date in A1? Thanks Jim |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add 24mo to a date
Jim wrote on Wed, 9 Sep 2009 11:17:02 -0700:
How do I write this formula to show (blank) if A1 is empty? And Can you help me with a formula that will poulate an X if the date in A1 is 3mo or less. X showing in B1. Thanks Jim "Mike H" wrote: Hi, =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) Mike "Jim" wrote: Hello, What formula would I use to add 24 months to a date in A1? Thanks Jim Isn't there a little problem with leap years and =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) 2/28/2008 2/28/2010 2/29/2008 3/1/2010 3/1/2008 3/1/2010 3/2/2008 3/2/2010 -- James Silverton Potomac, Maryland Email, with obvious alterations: not.jim.silverton.at.verizon.not |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
