The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Calculated end date / Gantt chart

posted Jun 5, 2021 6:15:41 PM

Topic Labels: Formulas

0 717 0

I am using a WORKDAY formula to calculate the end date of an event based on the duration. The formula I’m using is:

WORKDAY({*Start date},({*Days}-1)

However, this does not return a date field that can be clicked and dragged in Calendar and Gantt views. Is there a way that I can make that happen? I don’t mind having another field that converts that returned value to the correct format.

0 Replies 0