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