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.