Hi Fullen,

To calculate the number of days in YTD use:
Code:
=(DATE(TODAY())-DATE(YEAR(TODAY()),01,01))+1


OK?
_________________________
Andrew Bates