Formula Help - Remaining Hours To Be Worked In A Term, Equally Spaced Out Monthly



You've always been good to me. I'm hoping to get across the finish line for a formula I've been working on.

Here's what I have:

* Start Date, End Date, Working Days within that range (could be one week, could be ten years)

* Remaining Hours (total hours necessary to be worked within the Start & End Date)

I need a formula that uses the above fields to say "if X hours remain to be worked within the range, how many hours would that work out to for May 2023, June 2023, July 2023 (through the end of the term).

Many thanks.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!