Week day count in Forms

[prabhu]

In my forms, i need to calculate 30 working days/weekdays from today/everyday, i used DateAdd("w", 30,Date()), but it return only the calender days not the weekdays; How get weekday for period of 30days?

 

[Trevor G]

Look at this link to Microsoft there is an explanation

http://office.microsoft.com/en-us/a...-between-two-dates-in-access-HA001055078.aspx

 

[prabhu]

thanks, but this is to caluculate the no working days bw two dates, in my case, i need to calculate the 30th working day from today.

 

[Trevor G]

Surely the link gives you the details you need, you would adapt this to the parameters you need.