Add on 8 working days to a date
 

Hi

I need to add 8 working days (excluding Saturdays and Sundays) onto a
column of existing dates all of which may be different. I know I can
use the NETWORKDAYS function to work out the difference between 2 dates
but my problem here is that I only have one date and I need to add 8
working days onto it.

Any help would be much appreciated.

Shirley Munro


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=520514

Add on 8 working days to a date
 

Use the brother of NETWORKDAYS: WORKDAY()

--
Kind regards,

Niek Otten

"Shirley Munro"
wrote in message
news:Shirley.Munro.24eie2_1141905610.3774@excelfor um-nospam.com...

Hi

I need to add 8 working days (excluding Saturdays and Sundays) onto a
column of existing dates all of which may be different. I know I can
use the NETWORKDAYS function to work out the difference between 2 dates
but my problem here is that I only have one date and I need to add 8
working days onto it.

Any help would be much appreciated.

Shirley Munro


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile:
http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=520514

Add on 8 working days to a date
 

Thanks a lot Niek. This works just perfect.

Shirley Munro


--
Shirley Munro
------------------------------------------------------------------------
Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836
View this thread: http://www.excelforum.com/showthread...hreadid=520514