Formula question - date variable

We’re trying to track ad spend on a board and my eyes keep crossing trying to sort out a formula, hoping someone here might have ideas.

We have the spend coming in, trying to sort out how to trigger the formula to know what day it is to how much spend has occurred.

Does anyone know if there is a way to add a day of the month as a variable?

Not sure I understand your question. If you want to know which day is today then try


It will return 10 for Jan 10, 2023

Sorted it out with a big facepalm.

Hi @DeanneMc ,
If you set the date in a date column when the item is created then you could use :

And if not then :
FORMAT_DATE(Today(), “DD”)

It will give you day of the month as a variable
Let me know if you have any other questions