Sorry to be so unclear, I'll try again.

First I need to find out how many days there are between today and Col G.
Then I need to divide (yes, I flipped them incorrectly below) to find out
how many dollars/day are being made.

Row 2 has a date of 03/30/2006 and $1662.25 = 1662.75/(37366-37344) =
$75.56/day

Row 3 has a date of 04/11/2006 and $70.00 = 70.00/(37366-37356) = $7.00/day

It seems so simple, it's like the reverse of "TEXT", how to convert a date
to serial while in a date formatted cell.

Thank you so much for responding.


"DTTODGG" wrote:

Hello-
I have an excel file sent to me everyday.
Col G is formatted as "DATE" not general (2/8/2006)
Col H is a money field.

Col I - I want to find out how much money/day (formatted as "currency".

Take "today" - Col G and divide by Col H put in Col I.

The problem is Col G is not a "general" field. I suppose I could everyday
change Col G to "General", but then people can't figure out what date 37344
is.

Is there a clean way to do this?
Thank you so much - I hate working with dates in excel!