Formula Help...

  • Thread starter Thread starter Zoe
  • Start date Start date
Z

Zoe

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))
 
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
 
Back
Top