Hi Guys and thanks in advance to you more knowledgable friendly people.
Column E is a date column of first enquiry
what i need to be able to do in column F is add two days on
i could do =E3+2 and drap down the column but when i drag it down the column in preparation for any data entered in column E then it puts the date in as 02 January 1900 where as i would like the cell to remain blank.
also when the date in column f is reached ie today for example i would like the cell to go red.
Your help would be much appreciated
Bookmarks