Formula for # of days calculated from a date.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dylan56 (No_at_SpamAtAll.com)
Date: 03/27/04 

Date: Fri, 26 Mar 2004 19:00:27 -0500

I looked at so many formulas on the net but I'm obviously asking the
wrong question. I have a column in a work*** where we're going to
put the day a legal opinion was requested. That means the date the
legal request was sent up to the legal dept., in other words. In the
last column in this tracking log, I'd like the excel spread*** to
calculate how many days it's been since that request was sent, the
calculation based on today's date which is the date we print the
spread***.

So, for example, let's say I sent a legal request up to them this past
Wednesday. If I print out the spread*** today, the cell
corresponding to days elapsed since Wednesday would show "2" for 2
days.

What would the formula be, though? If I type in Wednesday's date in
cell B2, what formula would I put in cell B5 pls? (just to give the
cell numbers I'm working with).

Thank you so much! I hope my question was clear.

Quantcast