Adding business days to a calendar date

jmo

Hi team - I have several date columns but need to create a formula that adds a number of business days to a date. An example would be:

• Column 1: Today's date
• Column 2: Column 1 (Today) + 10 business days
• Column 3: Column 2 + 10 business days

Any help would be greatly appreciated.

Sameer Karkhanis

Column 1 will =TODAY()
Column 2 will be =WORKDAY(TODAY(), 10)
Column 3 will be =WORKDAY(TODAY(), 20) or you can have =WORKDAY([Column 2]@row, 10)

Sameer Karkhanis

Column 1 will =TODAY()
Column 2 will be =WORKDAY(TODAY(), 10)
Column 3 will be =WORKDAY(TODAY(), 20) or you can have =WORKDAY([Column 2]@row, 10)

jmo

Thanks @Sameer Karkhanis - that worked!

Here's another question - do you know how to count WORKDAY between 2 date columns?

Sameer Karkhanis

Use =NETWORKDAY([Start Date]@row, [Due Date]@row)