yup

=IF(A1="","",A1-WEEKDAY(A1)+1)

Mike

"Dylan @ UAFC" wrote:

would that work on this formula as well
=A1-WEEKDAY(A1)+7


"Mike H" wrote:

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