ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating automated timeline (https://www.excelbanter.com/excel-worksheet-functions/227574-creating-automated-timeline.html)

Ruki

Creating automated timeline
 
Trying to create an automated time line for a process (eg process starts on a
date, 5 days later step 2 happens, 3 days later step 3 happens, etc) but
ignoring weekend dates. Currently I am just using the date in the previous
cell, and adding the number of days relevant, but I don't know how to
generate business days (Mon - Fri) only.

Thanks,



All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com