Return date for the next coming weekday

**ElmerS** · 05-24-2010, 03:42 AM

Hi,

I need to return the next coming weekday as from todays date.
(The so called Todays dates were simulated in cells B1, F1, J1).

The formula, I've got, returns Todays date instead of 7 days ahead.
(See attached Workbook)

Thanks, Elm

**teylyn** · 05-24-2010, 03:45 AM

Elmer, I'm not quite clear why B6 should be 30/5 when B5 is already 30/5

Have a look at the Workday() function. In Excel 2003 you need to install the Analysis Toolpak. In Excel 2007 it's native.

**zbor** · 05-24-2010, 03:48 AM

Try change in your formula 7 with 8:

=MOD(7+(E5-WEEKDAY(F$1));8)+F$1

**ElmerS** · 05-24-2010, 04:17 AM

Thanks, teylyn:
It is my typo. It should read: "B2 should return 31/5"
As far as I understand Workday() function relates to weekends of Sat-Sun. and I'm looking for a global formula which can be used also when Fri-Sat. are the weekends.

Thanks, zbor:
If Today is Sat, 21/5, your suggested formula returns, for day 7, 21/05 instead of: 29/5.

Elm

**DonkeyOte** · 05-24-2010, 09:38 AM

Perhaps

B5: =B$1+7-MOD(WEEKDAY(B$1)-A5;7)
applied to all cells as appropriate

**ElmerS** · 05-24-2010, 10:26 AM

Instead of perhaps I would say: "Exactly" !

Thanks.

**daddylonglegs** · 05-24-2010, 11:10 AM

you can eliminate MOD......

=B$1+8-WEEKDAY(B$1-A5+1)

**ElmerS** · 05-24-2010, 12:51 PM

Thank you
.

Return date for the next coming weekday

LinkBack

Thread Tools

Rate This Thread

Display

Return date for the next coming weekday

Re: Return date for the next comming weekday

Re: Return date for the next comming weekday

Re: Return date for the next comming weekday

Re: Return date for the next comming weekday

Re: Return date for the next comming weekday

Re: Return date for the next comming weekday

Re: Return date for the next coming weekday

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions