calculate duration between 2 dates
I just want to simply add how many days it is from from the start date to the end date. I want the full duration, including weekends.
Forum Discussion
It depends how accurate it needs to be as to the complexity if the formula. It also depends if you want decimals.
The low tech way to Years is to just divide by 365.25. For months to multiply by 12/365.25.
The actual syntax will depend on whether your days calculation is a duration field or a numeric field.
The low tech way to Years is to just divide by 365.25. For months to multiply by 12/365.25.
The actual syntax will depend on whether your days calculation is a duration field or a numeric field.