G
Guest
Hi There
I need to calculate the number of workdays in a month for a totals query and my current formula seems to have some bugs....here's what I have..
WorkDaysInMonth: Day(DateAdd("m",1,[Date])-Day([Date])
Using this formula, if a record is entered for example, on the 30th or 31st of January, it's returning 30 and 29 days in the month. In addition, I need to calculate the number of weekdays instead of the total number of days. Any suggestions
Much thanks
Lynndyhp
I need to calculate the number of workdays in a month for a totals query and my current formula seems to have some bugs....here's what I have..
WorkDaysInMonth: Day(DateAdd("m",1,[Date])-Day([Date])
Using this formula, if a record is entered for example, on the 30th or 31st of January, it's returning 30 and 29 days in the month. In addition, I need to calculate the number of weekdays instead of the total number of days. Any suggestions
Much thanks
Lynndyhp