Displaying Day as a formula

[mstieler]

I'm working with a worksheet with one sheet per day of the month (we use a master, copy/paste, change the copy to the current month, and go from there). I've already got it to figure the dates based off (really difficult).

Please Login or Register  to view this content.

I know the formula to show a date as a day

Please Login or Register  to view this content.

but after working with it, can't seem to get it to work like I'd hoped.

I tried

Please Login or Register  to view this content.

but that didn't work; all it left me with was the text of the cell location.

Could someone help me with this issue?

[daddylonglegs]

I'm not sure what you're trying to do, are you talking about worksheet formulas? If so then if A1 contains a date then you can get the day with

=TEXT(A1,"dddd")

[martesoft]

Why don't you just use the first formula that you show, and set the format as ddd?

[mstieler]

The quotation marks were what was throwing it off. Thanks!