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