DATEDIF FUNCTION
 

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

Thanks,

J.

DATEDIF FUNCTION
 

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


"jT" wrote:

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

Thanks,

J.

DATEDIF FUNCTION
 

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" wrote in message
...
If $C$2 = today()-90, what does this formula mean please?
DATEDIF(("2006/1/1"/91),($C$2/91),"D")*13+$A29)

Thanks,

J.

DATEDIF FUNCTION
 

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


"jT" wrote:

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

Thanks,

J.