How to return date after adding amount of working days?

I need to get the date after adding x working day from starting date. What should i do?

For example,

Starting date is 1 June 2024, i need to show date after 5 working days If we count Sunday as holidays so it need to show in the cell as 7 June 2024.

Thanks.

  1. Start Function Wizard.
  2. On its Functions tab, type work into the search box.
  3. Check the resulting short list, to find WORKDAY function.

2 Likes