Hi there! I had this formula to calculate th...

(Aparicio Piñeyrúa) #1

Hi there!

I had this formula to calculate the days of birth: = HOUR([Date_today]-[Birth_date])/24 and shows me how many days have been past since the birth day, but it has a mismatch of 9 days comparing to reallity.

Check this example:

If I born in 2016 month 11 day 23 and today is 2018 month 10 day 25 if I calculate the months x 30 and the remanining days for the current month I had 692 days.

How can I change the formula to calculate the correct days between the birthday and today?


(Philip Garrett) #2


Would it suffice to simply subtract one date from the other? That would yield a Duration containing the days.

(Aparicio Piñeyrúa) #3


And how should I modify the formula?