You can use the Format function. But, there is a limit: 2958465 is the same as the 31 december of 9999. You can not go higher as this number.
Code:
Temp = Format("36826","dddd dd mmmm yyyy", vbMonday,  vbFirstJan1)
'Now, Temp will contain the date of today...
Hope this helps you ,
WP