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.

Due Date

Topic Labels: Formulas
Solved
Jump to Solution
2746 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! 🙂