Formula help - calculate next working Monday if working date is not a Monday

[mapwizard]

Hi Everyone

I'm not an Excel expert but i'm trying to create a specific formula to calculate product delivery dates for a business client, whereby the process goes something like this:

If today's date + 2 days(in my case this number will vary per product) equals a Monday, then return the Monday date. If it's not a Monday, then return the next working Monday. The crux is that the formula must only count working days(so exclude Saturday and Sunday), so TODAY()+2 should not factor in weekends.

I have the below formula so far:
=IF(WEEKDAY(WORKDAY(TODAY();2))=2;WORKDAY(TODAY();2);MOD(WORKDAY(TODAY();2);7))

I'm struggling to return the following Monday date, so if anyone can help me to solve this problem, I will be most grateful

Thank you

 

[Fluff]

How about

=WORKDAY.INTL(TODAY()+1,1,"0111111")

 

[LordVoldetort_IV]

How about

=WORKDAY.INTL(TODAY()+1,1,"0111111")

Dumb question, but how does the "0111111" part of this formula work? it seems kinda neat and i would like to understand it so i may be able to use it in other cases

 

[Fluff]

That's the weekend argument & it runs Mon to Sun. 0 is False so it's not a weekend & 1 is true so it is a weekend.
So in this case we are saying that Mon is the only work day.

 

[LordVoldetort_IV]

That's the weekend argument & it runs Mon to Sun. 0 is False so it's not a weekend & 1 is true so it is a weekend.
So in this case we are saying that Mon is the only work day.

Okay that makes sense, thank you!