Home |
Search |
Today's Posts |
#1
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
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
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
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|