ML - profile

ML · Jul 03, 2023

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/...

ML · Jul 04, 2023

Awesome thank you! They both do the job, though I'm still trying to figure out how @Sho 's solution works 

User Statistics

User Activity

Rounding a date to the half year

Re: Rounding a date to the half year