Add on 8 working days to a date

[Shirley Munro]

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

[Niek Otten]

Use the brother of NETWORKDAYS: WORKDAY()

--
Kind regards,

Niek Otten

"Shirley Munro" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Shirley Munro]

Thanks a lot Niek. This works just perfect.

Shirley Munro