ExcelBanter - Start Date

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

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

- - Start Date (https://www.excelbanter.com/excel-discussion-misc-queries/126354-start-date.html)

Daviv

Start Date

Is there a function that calculates the start date given the contract
duration and completion date while excluding the holidays? Similar to
workdays but reverse.
--
Thanks!

Sean Timmons

Start Date

OK, if you have the Analysis Toolpack add-in loaded,

=end date-workday(end date,number of workdays,holiday dates)

"Daviv" wrote:

Is there a function that calculates the start date given the contract
duration and completion date while excluding the holidays? Similar to
workdays but reverse.
--
Thanks!

daddylonglegs

Start Date

WORKDAY itself works in reverse, i.e. the second argument can be a negative
number so......

If completion date is in A1 and contract duration (in days) in B1

=WORKDAY(A1,-B1,holidays)

"Daviv" wrote:

Is there a function that calculates the start date given the contract
duration and completion date while excluding the holidays? Similar to
workdays but reverse.
--
Thanks!

All times are GMT +1. The time now is 02:25 AM.