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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1

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

0 equates to Saturday!

Try this:

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

--
HTH,

RD

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

"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:6c8a4f3960c8e@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1

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

Thank you it worked out great!!!!!



RagDyer wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Darts via OfficeKB.com" <u19990@uwe wrote in message
news:6c8b04f9bf846@uwe...
Thank you it worked out great!!!!!



RagDyer wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200701/1