Get rid of 1/5/1900 in my column with a formula to calculate 5 days into the future

[jholiday78]

Hello,

I have a formula in column C to calculate 5 days into the future of the date in column B. In some of the cells in column B there are no dates yet, so the formula that I copied down column C fills in the date of 1/5/1900.

What can I add to the formula in column C to get rid of 1/5/1900 and to show a blank cell until a date is filled into column B?

Here is the formula I am using in column C to calculate 5 days into the future of the date in column B:
=DATE(YEAR(B3),MONTH(B3),DAY(B3)+5)

Thanks for your help in advance!
Jessica

[daddylonglegs]

If B3 is a date you really only need B3+5, so to eliminate 1/5/1900 just use this formula

=IF(B3="","",B3+5)

and format C3 in required date format, e.g. m/d/yyyy

[jholiday78]

I love Excel Forum. Thank you so much. That formula is much simpler than what I was doing!

Jessica