G
Gary
In column B are dates displayed as dddd/mmmm/yyyy.
In column A are days of the week displayed as Mon, Tue, etc based on a
formula "=TEXT(B1,"ddd")".
The formula is ideal other than blank cells in column B return "Sat" in
corresponding column A cells. Is there a formula that would leave a cell
blank in A if there is no date yet entered in a corresponding cell in column
B?
Regards,
Gary
In column A are days of the week displayed as Mon, Tue, etc based on a
formula "=TEXT(B1,"ddd")".
The formula is ideal other than blank cells in column B return "Sat" in
corresponding column A cells. Is there a formula that would leave a cell
blank in A if there is no date yet entered in a corresponding cell in column
B?
Regards,
Gary