Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Help with Formula to calculate milestone date

Topic Labels: Formulas
427 6
cancel
Showing results for 
Search instead for 
Did you mean: 
MollyM
4 - Data Explorer
4 - Data Explorer

Please help I need a formula for reoccurring seasonal milestones.  We have seasonal launch dates and milestones in each season that occur at intervals;  -130 wks, -80 wks, -56 wks.  I want to calculate the due date of the milestone based on season launch date  & milestone -wks (-50wks) to generate the due date for that milestone.   Please help! 

6 Replies 6

This field deducts 130 weeks from the "Date" field, does this look right?

Screenshot 2024-09-18 at 9.33.38 AM.png
If so, the formula is

DATEADD(Date, -130, 'weeks')

And so you can try:

DATEADD(Date, {Weeks from launch formula}, 'weeks')

 

thank you for your reply, unfortunately it still not working.  I want to calculate the due date by taking the season start date field (MM/DD/YYYY) and subtracting a number of weeks (-130, -53, -35) for each record to come up with the due date. Does Airtable formula not recognize my field # wks -130 ( or any number of week) and able to subtract that number of weeks from the season start date?  

Hi,
The second @TheTimeSavingCo formula should work. Formula must include information - which unit you want to add/subtract, so instead of 'date' you should type 'week' or 'weeks'
Also, you should remove minus, otherwise you get   Date  -(-130) weeks  so it will add weeks instead of substract.
Of course, you should insert your field names,  Season Launch, Weeks from launch

I adjusted the formula in these two version and getting problem message and then #error?  Screenshot 2024-09-20 at 1.45.42 PM.pngScreenshot 2024-09-17 at 3.53.49 PM.png

Could you try creating a new formula field and pasting the following formula in?

DATEADD(Date, {Weeks from launch formula}, 'weeks')
OrahVick
4 - Data Explorer
4 - Data Explorer

Use this formula for milestone dates:

DATEADD({Start Date}, {Number of Days}, 'days')

Or, to exclude weekends:

WORKDAY({Start Date}, {Number of Days})

To understand anything that contains a circle, use pi.