ExcelBanter - workday calculation for backwards

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - workday calculation for backwards (https://www.excelbanter.com/excel-discussion-misc-queries/238388-workday-calculation-backwards.html)

oscar

workday calculation for backwards

I have already set up the scheduled completion date and working duration,
want a fomula to calculate the scheduled start date(work day). eg:
A B C
Start Date Duration Complete date
10 30-Oct-09
I need to know which workday on the columu "A" .
Thanks.

Niek Otten

workday calculation for backwards

=WORKDAY(C1,-B1)

Format as Date

If you get a #NAME error: ToolsAdd-insCheck Analysis Toolpak
--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Oscar" wrote in message
...
I have already set up the scheduled completion date and working duration,
want a fomula to calculate the scheduled start date(work day). eg:
A B C
Start Date Duration Complete date
10 30-Oct-09
I need to know which workday on the columu "A" .
Thanks.

All times are GMT +1. The time now is 07:57 AM.