When copying formula down it puts in a day of the week

[Darts via OfficeKB.com]

When copying formula down (when there is no date yet) it puts in a day of the
week when it should acutally should be blank. here is the formula used

TEXT(C8,"dddd")

thanks

 

[RagDyer]

0 equates to Saturday!

Try this:

=IF(C8="","",TEXT(C8,"dddd"))

 

[Darts via OfficeKB.com]

Thank you it worked out great!!!!!

0 equates to Saturday!

Try this:

=IF(C8="","",TEXT(C8,"dddd"))

When copying formula down (when there is no date yet) it puts in a day of
the

[quoted text clipped - 3 lines]

thanks

 

[Ragdyer]

Thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Thank you it worked out great!!!!!

0 equates to Saturday!

Try this:

=IF(C8="","",TEXT(C8,"dddd"))

When copying formula down (when there is no date yet) it puts in a day of
the

[quoted text clipped - 3 lines]

thanks