N
Neil
i have a formula that returns the day of a inoutted date.
=TEXT(f1,"dddd")
it works fine except for it will return a "saturday" if the cell is blank.
How can i adapt it to ignore the blank cell?
Many thanks
=TEXT(f1,"dddd")
it works fine except for it will return a "saturday" if the cell is blank.
How can i adapt it to ignore the blank cell?
Many thanks