Skip to main content
Solved

Formulas for dates

A

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. 

Column: Submitted date: (constant)- user entered 

Columns: Expected Project Return (date) 

DATEADD({SUBMITTED Date }, 10, 'week')) 
This checks out good. 
 
when I have a Resubmittal column(date) I would like the Expected Project Return Date to now show 
DATEADD({SUBMITTED }, 30, 'day')) 
So in short i want the expected return date column to update once the resubmittal date is updated. 

Best answer by bcrossley

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
{Resubmittal},
DATEADD({SUBMITTED}, 30, 'day'),
DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!

View original
Did this topic help you find an answer to your question?

4 replies

bcrossley
  • bcrossley
  • Inspiring
  • 10 replies
  • Answer
  • January 31, 2025

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
{Resubmittal},
DATEADD({SUBMITTED}, 30, 'day'),
DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!

Alexey_Gusev
Forum|alt.badge.img+12
  • Alexey_Gusev
  • Inspiring
  • 1111 replies
  • January 31, 2025

Hi,
I would use the formula provided by @bcrossley  , as better readable.
Just want to show you can transform formulas  in a different ways, like put the condition exactly where you need to change the value:

DATEADD({SUBMITTED Date}, IF(Resubmittal,30,70) ,'days')

 

A
  • Austin-Scheib
  • Author
  • New Participant
  • 2 replies
  • February 1, 2025
bcrossley wrote:

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
{Resubmittal},
DATEADD({SUBMITTED}, 30, 'day'),
DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!


Thank you for your help in resolving this. 

 

A
  • Austin-Scheib
  • Author
  • New Participant
  • 2 replies
  • February 1, 2025
Alexey_Gusev wrote:

Hi,
I would use the formula provided by @bcrossley  , as better readable.
Just want to show you can transform formulas  in a different ways, like put the condition exactly where you need to change the value:

DATEADD({SUBMITTED Date}, IF(Resubmittal,30,70) ,'days')

 


Thank you for the response the line worked.

Reply


Most helpful members this week

Terms & Conditions