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).

='[page name]'![date cell]+1

I know the formula to show a date as a day

[=TEXT("[date]", "dddd")]

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

I tried

=TEXT("[date cell]", "dddd")

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!