relative time
Oops, for total days:
=(DATE(YEAR(J7),MONTH(J7)+TRUNC(J6),DAY(J7))+DAY(D ATE(YEAR(J7),MONTH(J7)+TRU
NC(J6)+1,0))*(J6-TRUNC(J6))-J7)+1
and format the cell as General (it will probably default to date).
For a start date of 1/1/2005, this returned 103.3
for a start of 12/09/2005, this returned 103.71
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
assume your start date is in J7 and 3.41 is in J6
=DATE(YEAR(J7),MONTH(J7)+TRUNC(J6),DAY(J7))+DAY(DA TE(YEAR(J7),MONTH(J7)+TRUN
C(J6)+1,0))*(J6-TRUNC(J6))
--
Regards,
Tom Ogilvy
"jsc3489" wrote in message
...
Ok, say I have a number representing time. For instance, 3.41 months. I
would
like to calculate (with some accuracy) to how many days this is.
I have a reference date, and I use =DAY(DATE(YEAR(B4),MONTH(B4)+1,0))
to count the days in my reference date. I'm looking to "pick apart" the
3.41
to change my formula to the next month, count the days, etc.
I could then multiply .41 to the days in the 4th month and then add them
all
together to get my end result.
Trick is, to do any of the above. Any Takers?
--
I reject your reality and substitute my own.
Promote hydrogen - one of the best "clean" fuels there are!
|