Sorry I entered the wrong formula. Post should have read:
I need to get the Date function that shows day of the week cell (a3) to be empty when the date cell (R3) is blank. I am using the formula =TEXT(A3,”DDD”) in my day of week cell R3. When date cell (A3) is empty, day of week cell (R3) shows "SAT" instead for being blank like the date cell (A3). I don't see any references in the day of week explanation about this problem. I would like help with this.
Bookmarks