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!
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')
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')
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?
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
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?
I adjusted the formula in these two version and getting problem message and then #error?
Could you try creating a new formula field and pasting the following formula in?
DATEADD(Date, {Weeks from launch formula}, 'weeks')
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.