Need excel to see text where I have entered a formula.

**Clarabella** · 06-27-2012, 05:50 PM

I want to check IF="Sat" where Sat is the result of format ddd and date = base date +1

Any ideas?

**Richard Buttrey** · 06-27-2012, 06:36 PM

Perhaps

=IF(WEEKDAY(A1)=7,"Sat","Not Sat")

**Clarabella** · 06-28-2012, 09:15 AM

Hi Richard, Thanks for your quick reply. I am putting together a spread sheet where Mon-Fri = regular hourly rate for the first 8 hours and after that = Overtime as in "=(($G6-8)*$I6*CD6)+(8*CD6*$H6)". It worked great until I remembered that Saturdays and Sundays are all overtime. My dates are set up as 11/06/12 to start and then +1 in the next cell so I don't have to enter all the dates. Below that I have =cell above it but formatted as ddd to show day-of-the-week. Now I need to check the day of the week to see if it's Saturday or Sunday but my IF statement only reads the formula, not the resulting text.

I tried putting the Formula you gave me in the ddd cell but it didn't work. I even had the string for the entire week.

Thanks

http://www.excelforum.com/images/smilies/rolleyes.gif

**Richard Buttrey** · 06-28-2012, 09:25 AM

Hi,

I suggest you upload the workbook so that we can see the request in context. Manually add some results that you expect to see, and if it's not blindingly obvious a note explaining how you calculate the results,

**Clarabella** · 06-28-2012, 01:39 PM

Sorry Richard I cannot do that as yet. The file I am working on has confidential information in it. I will build a sample version that does not have the prohibited info. It will take a while

**Clarabella** · 06-28-2012, 02:27 PM

I have found the solution

If I use =TEXT(A2,"ddd")instead of =A2 formatted special as ddd, Excel read the resulting Day of the week as text and not as the formula it is.
Thanks for your help