As I work in the finance industry I often require calculations usin
days in a calendar year. However, I haven't been able to find
function that easily provide this integer based on a single cell dat
reference. If you know of a succint function that can replace thes
formulas please help:

Days in last year where date is 1 Jan 2003 (Cell $C$19):

=INT(($C$19-DATE(YEAR($C$19)-2,12,31))-($C$19-DATE(YEAR($C$19)-1,12,31)))

Days in current year (same date reference):

=INT(($C$19-DATE(YEAR($C$19)-1,12,31))+(DATE(YEAR($C$19),12,31)-$C$19))

Days in next year (same date reference):

=INT((DATE(YEAR($C$19)+1,12,31)-$C$19)-(DATE(YEAR($C$19),12,31)-$C$19))

Otherwise, if anyone is willing to share the VBA code to develop thes
formulas as a user defined add-in I would be most appreciable.

Thank you in advance for your help.

Cheers,
Shan

--
Message posted from http://www.ExcelForum.com