I need some help. I have a column I use for how many days late tasks are (Column “J”), but if Column “E” cells are blank it returns 48700 as a Value. Is there a way to have show blank, in Column “J”, when no date is entered in Column “E”?
Formula in Column “J” Row 1 is: =IF(F2>0,F2-E2,TODAY()-E2) Then copied down to row 50.
Note: there is a VBA to double click to enter dates in Columns D, E, F, G, & H
Bookmarks