Need help in trying to calculate the difference in months and days between two dates.
Q1: is it even possible to calculate difference and return result in month and days? Or is it only possible in either months OR days?
Q2: I entered a formula to only display difference in months, but choosing Jan 1 to Dec 31 is showing 11 months, and not 12 months. I get it that is subtracts and does not include Dec 31 in it’s calculation, but selecting the employement period dates (in our case) to be Jan 1 to Jan 1 would technically create confudion to the employee, as the period ends Dec 31. Any work around this. Super thanks in advance.
Solved! Go to Solution.
@Databaser, would the second “date unit” formula not result in total number of days, and concatenate it would be incorrect?
So, 3 months and 2 days, would end up being something like 3 months and 93 days? Or is there more to the concatenate formula that I am unaware of?