Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with Formula to calculate milestone date

Topic Labels: Formulas
1070 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.