networkdays

[ANYA]

I want to use networkdays to put together a time line, such as using
starting date then adding 6 days to get the next date and so on. Wha
does the formula look like for this? I tried A1 + 6 and got a date tha
included the weekend. Please help.:confused

 

[Dave Peterson]

Are you thinking of
=workday(a1,6)

Remember that the analysis toolpak addin must be loaded (tools|Addins)

 

[ANYA]

Hi Dave,

It worked!!!!

Thanks so much!

Anya