Skip to main content
Question

Finish Date Formula

  • Nov 10, 2020 8:33 PM UTC
  • 0 replies
  • 77 views
Hey everyone,

I'm attempting another formula without success. I have a start date, and a Rich Text - Formula field that calculates my final numbers to display a total in Days:

(ToText(Round(([3. Close Duration]+[3. Finish Duration]+[3. Rough Duration]+[3. Sub Duration])/8, 0.01) & " " & "Days"))

My question, is how can I get that number, being used with the Start Date to calculate the Finish date? I keep getting errors since it's 'text' and can't convert to a date. 

Any help would be appreciated!

Thanks,

------------------------------
Alex Bennett
------------------------------
This topic has been closed for replies.

  • AhuvaBrown
  • Observing
  • Nov 11, 2020 2:53 PM UTC
I think you just have misplaced parenthesis.
Try this:

ToText(Round(([3. Close Duration]+[3. Finish Duration]+[3. Rough Duration]+[3. Sub Duration])/8, 0.01))& " " & "Days"

------------------------------
Ahuva Brown
------------------------------
Terms & ConditionsAccessibility statement