Hi

=IF(A1<"",TEXT(A1,"dddd"),"")

Mke

"Dylan @ UAFC" wrote:

I am trying to auto fill or copy down this
formula, when I copy down Saturday shows up in every
cell, even if the orginal cell blank

How can I re-work the function so the cell will remain
blank until data is typed in the other cell