ExcelBanter - How do i add networkdays to a date?

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

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

- - How do i add networkdays to a date? (https://www.excelbanter.com/excel-discussion-misc-queries/44552-how-do-i-add-networkdays-date.html)

Eld7283

How do i add networkdays to a date?

I need to add 16 work days to date

What is the formula to add 16 days to 8/5/2005 ?

Peo Sjoblom

Look at the ATP function WORKDAY

=WORKDAY(A1,18,Holidays)

where A1 holds the date

--
Regards,

Peo Sjoblom

(No private emails please)

"Eld7283" wrote in message
...
I need to add 16 work days to date

What is the formula to add 16 days to 8/5/2005 ?

All times are GMT +1. The time now is 04:04 PM.