Event Countdown timer

Trying to create a countdown timer to add to my event details page.
Try as I might I can’t figure out the formula that would spit out ‘Weeks, Days, Hours, Minutes, Seconds’ based on a given day. Lets use 4th of July (7/4/2019) as the sample event date.

Attempting to create without a table aka a free form formula if that matters but I can use a table if necessary as well.

Appreciate the input!
Bit of a newb.

P.S. I read a similar/ older post here but it does not address my issue or provide a solution.

Dear @Mina_O

Does the below post make sense.

Credits to @jerols :trophy:

1 Like

Thanks @Jean_Pierre_Traets for the share! It’s a bit on the complex side though. Hope Coda team can implement a simple feature for this.
I just need a simple countdown timer or formulae :dizzy_face::grimacing:

@Mina_O

Have you tried using EventDate-Now()

2 Likes

@Mina_O

Try this. In the doc enter

=Date(2019, 7, 4)-Now()

1 Like

Thanks @mallika that was it. Not sure how I missed that :woman_facepalming:t5:

1 Like

Thanks very much @Nick_J!!