On Sun, 21 Aug 2011 23:02:02 -0400, Ron Rosenfeld
wrote:

On Fri, 12 Aug 2011 06:08:00 -0700 (PDT), StargateFan wrote:

I have a very specific formula that I need to keep the same. However,
I need to make the output come out as a weekday at all times. How can
I do this pls?

=CHOOSE(WEEKDAY(TODAY()+1),"Sn","Mn","Tu","Wd"," Th","Fr","Sa") &
TEXT(TODAY()+1,"\.mmm.dd.yyyy")

Thanks so much!! :oD

You can use the WORKDAY function.

=CHOOSE(WEEKDAY(WORKDAY(TODAY(),1)),"Sn","Mn","Tu ","Wd","Th","Fr","Sa")
& TEXT(WORKDAY(TODAY(),1),"\.mmm.dd.yyyy")

In versions of Excel prior to 2007, if you get a #NAME! error, look at help for the WORKDAY function for instructions as to installing the Analysis Tool Pak

Thanks, that's good to know re the Analysis Tool Pak.

Will give the formula a try, thanks! I spent hours on the weekend
trying to figure out how to do this. Thanks again for everyone's
help. Excel gets us out of tight spots! <g