View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin Fishlock Martin Fishlock is offline
external usenet poster
 
Posts: 694
Default 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.