Hi,
I'd appreciate any help with this formula.
Firstly, I have a spreadsheet with 4 headings from A1 – D1. (Name, Role, Actions, Date Submitted).
I have added an additional column in E1 (after Date Submitted) which tracks how many days has passed since ‘Date Submitted’. Formula I have used is: =TODAY()-D2.
The only problem with this formula is that if there is no date in the “Date Submitted” column, the formula comes back with “41458” under a number formatted cell, not date format.
How can I make the formula return a blank cell if there is no date in the column but when dates are added later on it will still calculate the number of days?
Thanks.
Bookmarks