|Trying to get a list of dates to insert the day (short version) into a spreadsheet, but if a date is not present I want it to insert a blank.|
Formula currently put into B3 =TEXT(C3,"ddd") with C3 having the date entered as 08/01/15.
This formula works fine i.e B3 = Thu and C3 = 08/01/15
I need it to then, when I copy the formula down to the following cells, to leave the 'day' (B3) blank if there is no date in C3.
I am sure this must be easy, but I can't work it out! Please help!
message edited by Sturtmoor02