Hi all,
The title might be a little confusing, so hopefully I can explain!
I have a spreadsheet where one column (E) has a date that a purchase order was created, then another column (H) that has a formula to show how long it has been since that purchase order was created. I am using the following formula in column H, which works great:
=DAYS360(E2,TODAY())
=DAYS360(E3,TODAY())
=DAYS360(E4,TODAY())
etc
etc
The problem I have is that if there is no data/date entered in the cell in column E, then answer to the formula in column H shows as 41049, which I do not want to see! Is there a way of the cells in column H being blank until a date is entered into column E?
Thanks in advance
Glenn
Bookmarks