How do I Calculate Number of days?
Status: Closed · Asked by zest83 on · 0 views
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 ?)
Attachments
As per list of Formulas: https://www.pabbly.com/spreadsheet-formulas/
I have used the DAYS formula
Got the Answer!
Attachments
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.