Hello! I'm new to Airtable and trying to create a formula field based on a date field. The formula should add 1 year to the date (the easy part), then round up to the half year beginning January 1 or July 1. For example, 5/15/23 would calculate 7/1/24; and 10/2/23 would calculate 1/1/25. Any and all help is appreciated!
Solved
Rounding a date to the half year
+3Best answer by kuovonne
You can see my thought process for coming up with the formula here in Kuovonne's Guide to Airtable.
Here is an early version of the formula. (For a better version of the formula, use the link to my guide.)
+29
You can see my thought process for coming up with the formula here in Kuovonne's Guide to Airtable.
Here is an early version of the formula. (For a better version of the formula, use the link to my guide.)
Hello @ML42_2 ,
This formula may also be fine.
DATEADD(
DATESTR("7/1/"&YEAR({Date})),
IF(MONTH({Date})>=7,18,12),
"month"
)
+3Awesome thank you! They both do the job, though I'm still trying to figure out how @Sho 's solution works 🙂
+29Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.