CODEWITHSUNDEEP
excelexcel-formula
Lisa Bullerman
Lisa Bullerman

Reputation: 9

Formula to calculate time frames

I created a worksheet where there are two dates:

  1. AppDate
  2. ActionDate

I need to calculate a new ActionDate that is 30 days after the earlier of the AppDate or ActionDate that is input.

For example, I have an AppDate of 10/30/13 and an ActionDate of 11/1/13. I need to calculate off of the 10/30/13 date to create the new action date (25 days out) and the 30 days from date.

The first app and action dates may be the same or may be different.

Is there a way to do this?

Upvotes: 0

Views: 986

Answers (2)

KyleMit
KyleMit

Reputation: 29839

As Tim has pointed out, the MIN(number1,number2,...) function in excel works perfectly fine on dates in order to determine the earlier date. Also, here's some more info on adding days.

So you can use something like this:

=MIN(A2:B2)+30

Which should like this:

demo

Upvotes: 0

Tim Ebenezer
Tim Ebenezer

Reputation: 2724

If the two dates are in cells A1 and B1, use the following formula - =MIN(A1,B1)+30

Upvotes: 1

Related Questions