Calculating date as decimal?

[Terry Pinnell]

If I have variables D = day (1-31), M = month (1-12) and Y = year (4
digits), does anyone know what formula (containing only D, M and Y)
Excel uses to calculate its decimal equivalent for that date please?

 

[David Biddulph]

=DATE(Y,M,D) and format as number or general.

 

[Terry Pinnell]

=DATE(Y,M,D) and format as number or general.

Thanks David but I wasn't as clear as I should have been. I want the
FORMULA not the function. Something along the lines of

X = (Y-1900)*365 + 31*M + D ... etc etc
but obviously much more complicated due to leap years and varying
lengths of the final year's months etc.