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.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Work weeks for a project duration
Amanda Baker
07-17-2019 16:43
I need a field to display total number of work weeks associated with a project duration. For instance, ...
Diana Miller
07-17-2019 17:30
Using the Ceil function should address your needs. Example: Ceil(ToDays([End Date]-[Start Date])/7)
Amanda Baker
07-17-2019 17:45
Thanks, Diana! Should I change the field type from Duration to Formula-Numeric?
Diana Miller
07-17-2019 19:06
For a Duration formula field type, you can use Weeks(Ceil(ToDays([End Date]-[Start Date])/7)) In the ...
1.
Work weeks for a project duration
1
Like
Amanda Baker
Posted 07-17-2019 16:43
Reply
Reply Privately
Options Dropdown
I need a field to display total number of work weeks associated with a project duration. For instance, if a project starts 7/17/19 and completes 8/1/19 it "touches" 3 work weeks. Can anyone help?
2.
RE: Work weeks for a project duration
0
Like
Diana Miller
Posted 07-17-2019 17:30
Reply
Reply Privately
Options Dropdown
Using the Ceil function should address your needs.
Example:
Ceil(ToDays([End Date]-[Start Date])/7)
3.
RE: Work weeks for a project duration
0
Like
Amanda Baker
Posted 07-17-2019 17:45
Reply
Reply Privately
Options Dropdown
Thanks, Diana! Should I change the field type from Duration to Formula-Numeric?
4.
RE: Work weeks for a project duration
0
Like
Diana Miller
Posted 07-17-2019 19:06
Reply
Reply Privately
Options Dropdown
For a Duration formula field type, you can use
Weeks(Ceil(ToDays([End Date]-[Start Date])/7))
In the field properties, set the Value Display to Weeks instead of Smart Units or any other option.
×
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