Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 28, 2023 11:54 AM
Sorry if this is a basic question— I am just starting out learning how to use formulas with little/no prior excel experience.
I have a formula that calculates the difference between today's date and the date a video was released. I have it returning the # of days:
Solved! Go to Solution.
Mar 28, 2023 01:48 PM
Hi @bdahl!
Welcome to the world of Airtable! We are happy to have you here. Please don't apologoize for asking any kind of question, we are here to help :).
To answer your question, yes formatting the output to appear as you requested is possible, but does require what could be a considered confusing formula (especially for a beginner). I will input my solution below, and the explain what each piece of the formula is doing.
DATETIME_DIFF(TODAY(), {Video Date}, "y") & " years "
&
DATETIME_DIFF(DATEADD(TODAY(),-DATETIME_DIFF(TODAY(), {Video Date}, "y"),"y"), {Video Date}, "M") & " months "
&
DATETIME_DIFF(DATEADD(TODAY(),-DATETIME_DIFF(TODAY(), {Video Date}, "M"),"M"), {Video Date}, "d") & " days "
Breaking it down:
Mar 28, 2023 01:48 PM
Hi @bdahl!
Welcome to the world of Airtable! We are happy to have you here. Please don't apologoize for asking any kind of question, we are here to help :).
To answer your question, yes formatting the output to appear as you requested is possible, but does require what could be a considered confusing formula (especially for a beginner). I will input my solution below, and the explain what each piece of the formula is doing.
DATETIME_DIFF(TODAY(), {Video Date}, "y") & " years "
&
DATETIME_DIFF(DATEADD(TODAY(),-DATETIME_DIFF(TODAY(), {Video Date}, "y"),"y"), {Video Date}, "M") & " months "
&
DATETIME_DIFF(DATEADD(TODAY(),-DATETIME_DIFF(TODAY(), {Video Date}, "M"),"M"), {Video Date}, "d") & " days "
Breaking it down:
Mar 29, 2023 06:03 AM
Wow— thank you so much! Yeah, I would have struggled with writing that on my own; it worked exactly as I wanted it. I REALLY appreciate you taking the time to explain the formula to me— it makes much more sense now. Thank you again!