Workdays() but for all days?

I see there is a handy function =WORKDAY(B2,2) for getting a day 2 days after, 5 would give that one week… (if you format the cell as a date), but is there no function like it to just calculate +n days not work days?

Doesn’t =B2+n work for you?

Workdays() but for all days?

WORKDAY.INTL(B2;2;"0000000")

WORKDAY.INTL()

Just add a number to a date, result is another date. Example:

  • B2: 2021-03-12
  • C2: =B2+7

=> result 2021-03-19 (or whatever default formatted for your locale).