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)) |
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)) |
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)) |
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)) |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com