Need to get next Weekday date

[paresh0459]

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

 

[schielrn]

Welcome to the Board!

Have a look at the workday function:

http://office.microsoft.com/en-us/excel-help/workday-HP005209339.aspx

Hope that helps.s

 

[paresh0459]

Thanks for quick reply.
I'm looking for way to find out the next weekday date automatically for each month going forward.
I have a date range which expands from current date to 2 days in future.
Now these 2 days must be next weekday (Monday or Tuesday) if current day is Thursday or Friday respectively.

Please let me know if there is any way to solve my problem.
Thanks.

 

[Jonmo1]

Welcome to the board...

Did you try the function described in the link schielrn provided?

 

[paresh0459]

Yes, i checked that page but don't think thats serves my purpose.

 

[T. Valko]

Yes, i checked that page but don't think thats serves my purpose.

Post SEVERAL sample dates and tell us what results you expect..

 

[paresh0459]

I'm using TODAY() in one cell(say A1) to get current date each time I open excel.
Now, I need to get date of Weekday after 2 days in another cell(say A2). Thus, my date range would be from A1 to A2.

Now,
If todays date is 6/30/2011, A2 must have 7/4/2011
If todays date is 7/1/2011, A2 must have 7/5/2011
If todays date is 7/4/2011, A2 must have 7/7/2011

 

[Jonmo1]

Those examples are not consistent...

7/4 is 2 working days from 6/30
7/5 is 2 working days from 7/1
7/7 is 3 working days from 7/4

if it's because 7/4 is a holiday, then it would look like

If todays date is 6/30/2011, A2 must have 7/5/2011
If todays date is 7/1/2011, A2 must have 7/6/2011
If todays date is 7/4/2011, A2 must have 7/6/2011

In which case you use this (as described in the link provided earlier)

=WORKDAY($A$1,2,$E$1:$E$10)

Where E1:E10 is a list of holidays to be excluded.

 

[paresh0459]

I'm sorry for making the mistake. Correct case would be
If todays date is 7/4/2011, A2 must have 7/6/2011

With the formula you provided, do I need to mention all the Weekend dates in Column E? It would be a long list and not a good idea. Is there any way around to do that also?

 

[Jonmo1]

I'm sorry for making the mistake. Correct case would be
If todays date is 7/4/2011, A2 must have 7/6/2011

With the formula you provided, do I need to mention all the Weekend dates in Column E? It would be a long list and not a good idea. Is there any way around to do that also?

No, just the Holidays.
That's why I wrote

Where E1:E10 is a list of holidays to be excluded.

And it's not actually required, that depends on if you want holidays excluded or not.
If you don't need/want holidays excluded, you just leave out that part

=WORKDAY($A$1,2)