DATEDIF FUNCTION

[jT]

If $C$2 = today()-90, what does this formula mean please?
DATEDIF(("2006/1/1"/91),($C$2/91),"D")*13+$A29)

Thanks,

J.

[Bob Phillips]

I think this part

DATEDIF(("2006/1/1"/91),($C$2/91),"D")

is a method to calculate the number of quarters, by dividing each date by 91
(approximately 3 months), and then treating them as days.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"jT" <j...@discussions.microsoft.com> wrote in message
news:34C94647-747B-4AC6...@microsoft.com...

[jT]

Thanks Martin!
The problem is I inherited this spreadsheet (that I have to use) and I am
trying to figure out what it's doing.

"Martin Fishlock" wrote:

> JT
>
> Chip Pearson gives an excellant discussion of the datedif function.
>
> See: http://www.cpearson.com/excel/datedif.htm
>
> Basically it computed the differce between two dates in the mode given here
> days (d) was specified.
>
> The function appears to be calculating quarters of a year and then adjusting
> it by a factor of 13 and anding some constant.
>
> Maybe if you could explain a little of the spreadsheet it may help.
>
> --
> Hope this helps
> Martin Fishlock