Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.8K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How do we get the weekdays in a month?
Mary Pearl
07-20-2017 09:07
We need to compute for below formula: Utilization % = Total Actual Hour / (Weekdays in a month * 7.5) ...
QuickBaseCoach Dev./Training
07-20-2017 11:36
Assuming that you have a date field to indicate the month, ToDays(LastDayOfMonth([My date field]) ...
Mary Pearl
07-20-2017 12:07
should I create a 2 date field ?
QuickBaseCoach Dev./Training
07-20-2017 12:31
sorry, I am not understanding your question. You asked how many weekdays there are in a month. Which ...
1.
How do we get the weekdays in a month?
1
Like
Mary Pearl
Posted 07-20-2017 09:07
Reply
Reply Privately
Options Dropdown
We need to compute for below formula:
Utilization % = Total Actual Hour / (Weekdays in a month * 7.5)
How do we get the weekdays in a month?
2.
RE: How do we get the weekdays in a month?
0
Like
QuickBaseCoach Dev./Training
Posted 07-20-2017 11:36
Reply
Reply Privately
Options Dropdown
Assuming that you have a date field to indicate the month,
ToDays(LastDayOfMonth([My date field]) -FirstDayOfMonth([My date field])) + 1
3.
RE: How do we get the weekdays in a month?
0
Like
Mary Pearl
Posted 07-20-2017 12:07
Reply
Reply Privately
Options Dropdown
should I create a 2 date field ?
4.
RE: How do we get the weekdays in a month?
0
Like
QuickBaseCoach Dev./Training
Posted 07-20-2017 12:31
Reply
Reply Privately
Options Dropdown
sorry, I am not understanding your question.
You asked how many weekdays there are in a month. Which month?
Maybe it's good enough to use 365.25 / 12 = on average 30.4 days in a month.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic