Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Year to Date formula

284 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I need to create a Year to Date field that calculates YTD pay, but I am unsure of the formula to use. All help is appreciated.

1 Reply 1

There isn’t enough detail in your question to answer it accurately so here’s a guess:

{Pay Rate} * DATETIME_DIFF(TODAY(), {Date Field}, 'years')

This assumes that the pay rate is an annual figure, which is why it is being multiplied by the number of years since some start date and “today”. Change “years” to “months” or “weeks” or whatever if that’s more appropriate.