Posted to microsoft.public.excel.misc

StargateFan[_2_] StargateFan[_2_] is offline

external usenet poster

Posts: 12

Change to formula to make it go to next weekday (i.e., avoid weekend days)?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula help: Duration Without Weekend Days	JP	Excel Discussion (Misc queries)	4	November 9th 09 01:46 PM
Calc occurrances for weekday omitting weekend data	dtoney	Excel Worksheet Functions	4	October 23rd 09 04:31 PM
if formula returns a weekend - move it forward to next weekday	Z-Man-Cek	Excel Worksheet Functions	2	May 14th 08 09:45 PM
Formula to Remove Weekend Days	Tom	Excel Discussion (Misc queries)	1	May 24th 06 04:31 PM
Change the text format for weekend days (Sat, Sun)	Bhupinder Rayat	Excel Worksheet Functions	3	January 11th 06 04:10 PM

All times are GMT +1. The time now is 02:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us