Networkdays?

[sandybam]

Hi All,

I would like to figure out how to identify a future date using an identified date and adding only work days in Excel. So for instance, today is 7/15 what date would it be 20 work days from now (M-F)?

Thank you for your help.
Sandy

 

[SkipVought]

Hi

take a look at WORKDAY()

Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie![/sub]

 

[GlennUK]

It's

=WORKDAY(TODAY(),20,Bank_Holiday_List)

where you can have a list of holidays to take into account too.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[sandybam]

Works like a charm! Thank you,