Thread
:
TEXT date
View Single Post
#
1
Posted to microsoft.public.excel.misc
Neil
external usenet poster
Posts: 173
TEXT date
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
Reply With Quote
Neil
View Public Profile
Find all posts by Neil