lcor

asked on

# Excel 2010 Date Difference Formula

Does anyone know how to do the following:

Cell 1 Cell 2 Cell3

------- ------ -----

Date1 Date2 Result

The macro needs to do following: Take the difference between Date1 and Date2, where Date2 is farther out. The Result is true if the difference in dates in number of days is less than a specific number (say, 90).

Cell 1 Cell 2 Cell3

------- ------ -----

Date1 Date2 Result

The macro needs to do following: Take the difference between Date1 and Date2, where Date2 is farther out. The Result is true if the difference in dates in number of days is less than a specific number (say, 90).

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Then, in C1 you'd write:

=(B1-A1)>90