Formula for # of days calculated from a date.

[Dylan56]

I looked at so many formulas on the net but I'm obviously asking the
wrong question. I have a column in a worksheet 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 spreadsheet 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
spreadsheet.

So, for example, let's say I sent a legal request up to them this past
Wednesday. If I print out the spreadsheet 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.

 

[Frank Kabel]

Hi
try the following in B5
=TODAY()-B2
and format the resulting cell as 'General'

 

[Dylan56]

Hi
try the following in B5
=TODAY()-B2
and format the resulting cell as 'General'

Thank you so much, Frank! This works perfectly!

Now I know what people mean when they ask how to keep a cell blank
when the row is empty, though <g>. In the rows where no data is
entered at all yet, weird numbers appear in B5. Once I entered a
fictitious date in B2, _then_ that changes to a recognizable and
logical number. I believe there's a way that one can change the
formula so that if there is no value in B2, that the result in B5 is
blank instead of gibberish appearing? How would I modify the above
coding so that B5 appears blank until data is entered in the rest of
the row?

Thank you so much for this! My supervisor and boss will both be
happy. This new log sheet shows at a glance just how long the Legal
department is taking in sending us an opinion! I also added a column
in B6 that changes the number of days to # of months in a fraction
format so that it _really_ brings home who we have to chase to get the

 

[Frank Kabel]

Hi
try
=IF(B2<>"",TODAY()-B2,"")

 

[Dylan56]

Hi
try
=IF(B2<>"",TODAY()-B2,"")

Awesome, I just emailed the coding to myself at the office! Will

 

[Dylan56]

Awesome, I just emailed the coding to myself at the office! Will
modify it first thing. <g>

Thank you! It worked perfectly. Can't thank you enough.