Sign in to join the conversation:
How would I calculate the time between two dates (start and finish) in Weeks and Days
"8weeks 4days"
https://app.smartsheet.com/b/publish?EQBCT=dcf71ecb7f184467ab8f5debb68a04da
I've got it set up for days not weeks, but it shouldn't be hard to adjust. just pick which input strategy you want, rename your column names in your sheet to my column names, copy paste the formulas over, then name the columns back to what you want.
or if you want less precise ( no hours minutes) you might try something like:
=ROUND(NETDAYS([Start Date]1, [End Date]1) / 7 - 0.5) + " Weeks and " + (NETDAYS([Start Date]1, [End Date]1) - (ROUND(NETDAYS([Start Date]1, [End Date]1) / 7 - 0.5)) * 7) + " Days"
https://community.smartsheet.com/profile/L_123
(ROUND(NETDAYS([Start Date]1, [End Date]1) / 7) itself will round off to the whole number right, what is the purpose of - 0.5 in your formula?
It's a crude version of a rounddown() from before that function existed. Just round() might round up, and add a week to the total if the extra number of days was more than 3.5. So you take .5 away, and it can't round up.
Hi all, I am working with two Smartsheet sheets: Projects Intake & control Sheet Project Status / Status Update Sheet The goal is to use the Intake Sheet as the source/master sheet and automatically pull values into the Status Update Sheet based on a matching Project ID. For example, in the Status Update Sheet I want to…
Hey Team, So here's the situation, I need to report on a dataset, grouped by client name, then by job number: I'm importing a dataset into Smartsheet; filenames should be in the below format: Great. I can run a formula to break this up and run the report. Right? The issue Human error. Some examples of incorrectly named…
I'm coding a Solution where a Shift Lead needs to set up a dynamic list of 10-25 people to cover that shift's teaching assignments. The people fall under four categories—FT Staff, PT Staff, Volunteers, and Interns, with a max of 10 people per category—and I have separate columns for each, using drop-down menus from a…
