Help

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

Due Date

Topic Labels: Formulas
Solved
Jump to Solution
2251 5
cancel
Showing results for 
Search instead for 
Did you mean: 
newbie
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

DATEADD(
  IF(
    {Date B},
    {Date B},
    {Date A}
  ),
  16,
  "months"
)

Link to base

See Solution in Thread

Ah hmm, try this?

IF(
  OR(
    {Date A},
    {Date B}
  ),
  DATEADD(
    IF(
      {Date B},
      {Date B},
      {Date A}
    ),
    16,
    "months"
  )
)

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try something like:

DATEADD(
  IF(
    {Date B},
    {Date B},
    {Date A}
  ),
  16,
  "months"
)

Link to base

newbie
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much! 🙂

hi, follow - up question. How to leave the Due Date field blank if either of date A and Date B are empty?

Ah hmm, try this?

IF(
  OR(
    {Date A},
    {Date B}
  ),
  DATEADD(
    IF(
      {Date B},
      {Date B},
      {Date A}
    ),
    16,
    "months"
  )
)

Thank you so much! 🙂