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
------------------------------

davidbrowne · Answer

This worked great.&nbsp; Thank you!------------------------------David Browne------------------------------

markshnier__you · Answer

try this as a formula checkbox fieldMonth([Work Order Start Date]) = Month(Today())and DayOfWeek([Work Order Start Date]&gt;=1and&nbsp;DayOfWeek([Work Order Start Date]&lt;=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------------------------------

davidbrowne · Answer

Month([Work Order Start Date]) = Month(Today())
and DayOfWeek([Work Order Start Date]>=1
and DayOfWeek([Work Order Start Date]<=5)

Its telling me ">=" can not be applied as an operator on date, number.

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

markshnier__you · Answer

I was missing a few closing bracketsMonth([Work Order Start Date]) = Month(Today())and DayOfWeek([Work Order Start Date])&gt;=1and&nbsp;DayOfWeek([Work Order Start Date])&lt;=5)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Count Work Orders Started on Weekdays

Related Content

Auto-ordering or Auto-issuance system

Pipeline Not Starting

Start Audit Date

Formula to find weekdays for a duration

UPSERT Order processing preferences