WORKDAYS - Future date then moved forward to the next working days

[Stephanie Rance]

I am trying to create a formula that takes todays date, adds a specific term (in months) then if the date in the future is a weekend it then moves it forward to the next working day.
E.g. Today 13/02/2018 add 1 months is 13/04/2019 which is a Saturday so I would want the formula to then shift the date to 15/04/2019.

Any help is greatly appreciated!

 

[AliGW]

That's two months ...

Neither 13/03 nor 13/04 is a Saturday this year!

One or two months? Take your pick:

=IF(WEEKDAY(EDATE(A1,1),2)=6,EDATE(A1,1)+2,IF(WEEKDAY(EDATE(A1,1),2)=7,EDATE(A1,1)+1,EDATE(A1,1)))

=IF(WEEKDAY(EDATE(A1,2),2)=6,EDATE(A1,2)+2,IF(WEEKDAY(EDATE(A1,2),2)=7,EDATE(A1,2)+1,EDATE(A1,2)))

If you want a year and two months, let us know - your request is contradictory!!!

For 14 months:

=IF(WEEKDAY(EDATE(A1,14),2)=6,EDATE(A1,14)+2,IF(WEEKDAY(EDATE(A1,14),2)=7,EDATE(A1,14)+1,EDATE(A1,14)))

 

[Stephanie Rance]

Ah sorry that was meant to say 14, not 1! Thank you this works brilliantly.

 

[bosco_yip]

Or.......for Date + 14 months :

=EDATE(A1,14)+TEXT(2-MOD(EDATE(A1,14),7),"0;\0;0;")

Regards
Bosco

 

[AliGW]

Ah sorry that was meant to say 14, not 1! Thank you this works brilliantly.

You're welcome!