Making a text box count days but take away weekend days

[swarv]

Hi all,

I have a simple form here with 3 text box and 2 buttons. When I click the first button it brings up a calendar box and I can click on a range of dates and it fills in the start date into textbox 1 and the end date into textbox 2. Textbox 3 then calculates how many days there are between the 2 boxes using this code:

=[txtenddate]-[txt_date]+1

But I want it so that it takes into account weekends. What is the best and simplest way of doing this?

Thanks
Martin

 

[namliam]

Did you search the forum? This has been answered about a 1.000 times this year alone.

 

[swarv]

will do now, cheers