formula to subtract dates with an if clause

zbz826

New Member
Joined
Sep 12, 2005
Messages
7
Need a quick formula if anyone can help - any help is appreciated

Here's the scenario:

Column A contains past and future dates
Column B contains today's date with the formula =TODAY()

I need a formula in Column C that will give me how many days have passed since the past dates in Column A while leaving a blank if Column A contains a future date.

For example, the end product would look like this:

Col A Col B Col C
10/11/06 10/12/06 1
10/10/06 10/11/06 2
11/2/06 10/11/06
10/1/06 10/11/06 10

Anyone? I'm terrible with IF clauses but need to get this together for a meeting this afternoon - sorry for the rush!!
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

bakerman

Board Regular
Joined
Sep 9, 2005
Messages
188
I fairly new to excel, but this is how i would do it. In cell D1 put in =today()
then in Cell C1 put the following formula and copy it down
=IF(A1<=$D$1,DAYS360(A1,$D$1),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,726
Members
410,702
Latest member
clizama18
Top