Dates to ignore weekends

[nparsons75]

Hi, I have 10 columns, in Column A I have the formula =today()

so, this shows todays date. In column B I have the formula, =A1+1 (showing tomorrows date).

I need to do this across all columns with column A always showing the current days date.

The main issue is that as we go across the columns, when we come to a weekend date (Sat or Sun) I need it to miss these and go straight to the Monday date.

Would this be possible?

Thanks,

 

[wideboydixon]

Change column B formula to this:

=WORKDAY.INTL(A1,1,1)

This finds the next day that isn't a Sat/Sun. You can then copy the formula across.

WBD

 

[nparsons75]

Brilliant, thank you...