How do you count to 7?
My anniversary date at Microsoft is complexified by my leaving and coming back, so I don't really have an anniversary date so much as I have an anniversary Excel formula. It occurred to me this weekend that my 7 year anniversary might be coming up, so I worked out my anniversary Excel formula:
=DATE(2007,3,30+(7*365.242199-(DATE(2000,2,1)-DATE(1993,6,28))))
It turns out I missed it: it was August 24th. (Technically, it was August 24.69539, but I'm going with the 24th)
Happy 7 years to me - it only took me 14 years, 1 month, 26 days and 4 hours (or so) to get there. 
Comments