I know I can use the duration formula to obtain the number of days from one date to another, but I can’t seem to find an effective way to countdown from end date to start date in a way that display as x years, y months, z days to event.
1 Like
Yes, but that only shows the count down in days. For long term planning and mid term planning, I don’t see an effective way to create a confirm that might give a value of say 12 years, or 2 years 3 months and 10 days. It’s not useful to have a value of 4380 days.
1 Like
Dear @Lizeth_P_Gomez_Uscategui,
This should solve your question:
Where the column with the days is called [[Total Days] 
Of course you can put there the name of your column.
TIP: " Years ", " Months ", " Days " you can translate to the language of your choice if you create the document in a different language!
CONCATENATE(INT([Total Days]/365)," Years ", INT(MOD([[Total Days],365)/30), " Months ", MOD(MOD([[Total Days],365),30), " Days ")
Amicable,
@Jean_Pierre_Traets
1 Like
Thank you. Unfortunately, this doesn’t take into account months where there are 31 days
1 Like