Thread: TEXT date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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