Value in one cell based on day of week referenced by a date in another cell

[gibson2503]

I have a worksheet where column C contains dates and column G is a number. How do I make cell G1 a certain value if the date in C1 is a Saturday, and a different value if C1 is any other day?

[igoodable]

=if(text(c1,"ddd")="sat",enter your value here if true, enter your value here if false)

[Jonmo1]

There are several ways...

Can you be more specific...
What exactly do you want G to be based on Which Day's in C ?

[gibson2503]

=if(text(c1,"ddd")="sat",enter your value here if true, enter your value here if false)

This worked like a charm. Thanks igoodable!

[Ace_XL]

another way..

=IF(WEEKDAY(A1)=7,value if true, value if false)