Pickup next working day from a date which is Saturday or Sunday

[robrice108]

If a particular date is a Saturday or Sunday how can i flag this to pick up the next working days date i.e. the following monday

 

[MARK858]

Have a read of the link below....

https://exceljet.net/formula/next-working-day

 

[robrice108]

Hi Mark, thanks for the link however I can't seem to get this to work. The dates that are Sunday work fine but anything on Saturday is picking up Sundays date but I want it to be picking the Mondays i.e +2.

 

[MARK858]

Works fine for me...

Excel Workbook
	A	B	C	D
1	Sat 01/09/2018			Mon 03/09/2018
2	Sun 02/09/2018			Mon 03/09/2018
Sheet1

 

[robrice108]

Brilliant. Thanks Mark everything is now ok