Adding only working days
 

I hace a cell with a value, that value represents a number of working days
(no Sat. and Sun.)
I need to add that value to today's date and come up with a date that is not
a week end date.
Basically,, I need to add X working days to today's date.

Any help gratefully appreciated.

Adding only working days
 

See the WORKDAY function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Leon" wrote in message
...
I hace a cell with a value, that value represents a number of
working days
(no Sat. and Sun.)
I need to add that value to today's date and come up with a
date that is not
a week end date.
Basically,, I need to add X working days to today's date.

Any help gratefully appreciated.

Adding only working days
 

Thanks, Chip

For some reason I was using NETWORKDAYS and I was stuck.

Thanks again.

"Chip Pearson" wrote:

See the WORKDAY function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Leon" wrote in message
...
I hace a cell with a value, that value represents a number of
working days
(no Sat. and Sun.)
I need to add that value to today's date and come up with a
date that is not
a week end date.
Basically,, I need to add X working days to today's date.

Any help gratefully appreciated.