Count Work Orders Started on Weekdays

Question

I need a report formula that will count the current month's work orders that are started on weekdays only. Any ideas?

This is where an am so far:
IF (Month([Work Order Start Date]) = Month(Today()), Count([Work Order #]))

Thanks.

------------------------------
David Browne
------------------------------

MarkShnierYou · Answer

try this as a formula checkbox fieldMonth([Work Order Start Date]) = Month(Today())and DayOfWeek([Work Order Start Date]>=1and DayOfWeek([Work Order Start Date]<=5)Then you can run a report and filter on this field.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community