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

Calculate Sending Birthday Card

Topic Labels: Formulas
1018 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I need a formula for calculating when to send a birthday card that will return a date 10 days prior to the person’s birthday. So if the person’s birthday is 10-10-2019, I want the formula to calculate 10 days prior, or 09-30-2019, returning a date format. Any ideas on that? TIA

2 Replies 2

Assuming the persons birthday date is in a field called Birthday, put this formula into your Send Card by: field:

DATEADD(Birthday,-10,'days')

Thank you so much for helping out this newbie! Perfect solution!