Date function

[#1]

Is it possible to get the day's between two dates excluding the weekend?

For example:

Startdate          Endate

08-09-2011       13-09-2011    

[#2]

Hi,

have u tried with "networkdays" function?

C u,

Stefano

[its_anandrjs]

Hi,

Use Networkdays( ) function to get the day diference.

Regards

Anand

[its_anandrjs]

Hi,

Use Networkdays function in your scenario some thing like

=networkdays( '2011-09-08','2011-09-13',"SAT","SUN" )

it returns 4

Regards

Anand

[its_anandrjs · Accepted solution]

Hi,

See the attached sample file it explains networkdays between selected dates

by use

= Networkdays( '2011-09-08','2011-09-13',"SAT","SUN" )

HTH

Regards

Anand

[#6]

Thank you for the fast respons!

[#7]

You can also set up an inline table or read from another file declaring public holidays and exclude them too when using the networkdays() function.