Automatic Days Remaining Calculation in Stackby Content Calendar

Ask the Community Formulas
#1

I’m managing a content calendar, and I want to automatically calculate the number of days remaining until the publication date of each article. How can I achieve this in Stackby?

#2

Hey,

You can use the DATEDIFF() function to calculate the number of days remaining until the publication date. Create a new column and use the formula:

DATE_DIFF({Publication Date}, TODAY(), "days")

This formula calculates the difference between the publication date and the current date, giving you the number of days remaining.

I hope you can now achieve this now!