|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2010, 10:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help...
I'm calculating a date 5 years in advance for a lot of cells. If the original
(J4) date is blank how do I tell it to leave the new date blank also? Does that make sense? Thansk. =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)) 
|
|
#2
April 15th, 2010, 10:47 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help...
Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4)))
"Zoe" wrote: I'm calculating a date 5 years in advance for a lot of cells. If the original (J4) date is blank how do I tell it to leave the new date blank also? Does that make sense? Thansk. =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
|
|
#3
April 15th, 2010, 10:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help...
That worked perfect!!!! Thank you so very much!!!
"ck13" wrote: Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))) "Zoe" wrote: I'm calculating a date 5 years in advance for a lot of cells. If the original (J4) date is blank how do I tell it to leave the new date blank also? Does that make sense? Thansk. =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
|
|
#4
April 17th, 2010, 03:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Help...
Hi. Just note that if the original date is 2/29/2004
then Year(J4)+5 rounds forward to Mar 1 EDate rounds back to Feb 28. If you wish to round back, then maybe: =IF(J4="","",EDATE(J4,60)) = = = = = Dana DeLouis On 4/15/10 5:56 PM, Zoe wrote: That worked perfect!!!! Thank you so very much!!! "ck13" wrote: Try =IF(J4="","",DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))) "Zoe" wrote: I'm calculating a date 5 years in advance for a lot of cells. If the original (J4) date is blank how do I tell it to leave the new date blank also? Does that make sense? Thansk. =DATE(YEAR(J4)+5,MONTH(J4),DAY(J4))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
