Date subtraction

[xdzgor]

Hi
I am trying to convert a function from a VB (version 6.5) macro in Excel 2007 to c#. But there is a date calculation which I don't understand. Can someone please tell me what the following does?

Please Login or Register  to view this content.

etc

Thanks,
Peter

[Richard Buttrey]

Hi,

The user types =CalcRate(date) in Excel, where date is a valid date number.

The function evaluates two date variables. Dmin1 evaluates to the 1st January for the year containing the date passed, and the Dplus1 evaluates to the 1st January for the following year. So if the date passed is say 13 March 2009, Dmin1 = 1 Jan 2009 and DPlus1 = 1 Jan 2010.

The B variable takes the number of days between the date passed and the next 1st Jan and divides this by the number of days between 1st Jan in the date year and the 1st Jan in the following year.

i.e. it's working out the % of the calendar year that's left as a decimal.

HTH