Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 18, 2023 06:58 PM
hi, asking for help,
I made a database of my office documents and i need a formula for due dates that is due on 16 months, however the due dates will correspond to two (2) date fields, ex. date A and date B, the condition is this; if date B is not empty, due date will correspond to date B + 16 months, but if date B is empty, due date will correspond to date A + 16 months.
I hope someone help me, thank you!
Solved! Go to Solution.
Feb 19, 2023 12:13 AM
Try something like:
DATEADD(
IF(
{Date B},
{Date B},
{Date A}
),
16,
"months"
)
Feb 19, 2023 10:38 PM
Ah hmm, try this?
IF(
OR(
{Date A},
{Date B}
),
DATEADD(
IF(
{Date B},
{Date B},
{Date A}
),
16,
"months"
)
)
Feb 19, 2023 12:13 AM
Try something like:
DATEADD(
IF(
{Date B},
{Date B},
{Date A}
),
16,
"months"
)
Feb 19, 2023 04:59 PM
Thank you so much! 🙂
Feb 19, 2023 05:39 PM
hi, follow - up question. How to leave the Due Date field blank if either of date A and Date B are empty?
Feb 19, 2023 10:38 PM
Ah hmm, try this?
IF(
OR(
{Date A},
{Date B}
),
DATEADD(
IF(
{Date B},
{Date B},
{Date A}
),
16,
"months"
)
)
Feb 19, 2023 11:21 PM
Thank you so much! 🙂