Sep 17, 2024 04:12 PM
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!
Sep 17, 2024 06:35 PM
This field deducts 130 weeks from the "Date" field, does this look right?
If so, the formula is
DATEADD(Date, -130, 'weeks')
And so you can try:
DATEADD(Date, {Weeks from launch formula}, 'weeks')
Sep 18, 2024 12:58 PM
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?
Sep 18, 2024 05:20 PM
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
Sep 20, 2024 01:52 PM
I adjusted the formula in these two version and getting problem message and then #error?
Sep 20, 2024 10:12 PM
Could you try creating a new formula field and pasting the following formula in?
DATEADD(Date, {Weeks from launch formula}, 'weeks')
Sep 23, 2024 03:56 AM - edited Sep 23, 2024 09:21 PM
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.