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!!
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!!