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!
Page 1 / 1
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"
)
Awesome thank you! They both do the job, though I'm still trying to figure out how @Sho 's solution works 🙂
Awesome thank you! They both do the job, though I'm still trying to figure out how @Sho 's solution works 🙂
@ML42_2 wrote:I'm still trying to figure out how @Sho 's solution works 🙂
It's a neat solution. I added a discussion of it to the page I linked to in my previous post.
@kuovonne Excellent explanation!
I agree that using Datetime_parse is a sure thing
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.