Need to get next Weekday date

paresh0459

New Member
Joined
Jun 30, 2011
Messages
7
Hi, I need to find out next weekday date.
Currently I'm using TODAY() to get today's date. For me Date range is today's date plus 2 working days.
Can you help me achieve this requirement in Excel?

Thanks in advance
Paresh
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
It works as i want it to be. Thanks a lot for helping!

Glad to help..

In the future, it is wise to always at least try suggested solutions.
Even if you think it won't work.
In fact, especially if you think it won't work.

At worst, the suggestion doesn't work..
You didn't have resolution to begin with, so you've lost nothing but a few minutes.

At best, it does exactly what you want.

In the middle, it doesn't work, but you may learn something about something else that was unrelated..
So you've gained knowledge anyway through the trial and error process.
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,280
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top