How do I Calculate Number of days?

[zest83]

The Date Duration Calculator (Beta) Trigger is showing the Month and Days

How does one break down the number of months into Total Number of Days?
So Suppose a Project is from 1/2/2023 to 1/3/2023 - It should give the answer of 28 days but it says 1 Month.

So Each Month has been defined with its number of days.
Have you accounted for Leap Year? Feb having 28 and 29 days?

I need the total number of days.
How do I calculate number of days if I am getting an answer saying Month: 1 (So many days will this month have ... 28,30,31 ?)

 

[zest83]

As per list of Formulas: https://www.pabbly.com/spreadsheet-formulas/
I have used the DAYS formula

Got the Answer!

 

[PabblyMember4]

Hey @zest83

It seems like you have found the solution to the query you have raised. Please let me know if you have any questions or comments.