xdate in Windows 7

  • Thread starter Help with scheduling issue
  • Start date
H

Help with scheduling issue

I finally entered the world of Windows 7, albeit only because my laptop died.
I am a historan who needs to calculate dates into the 18th century. Xdate
always worked just fine in Excel 2003, but when I load it into the new
computer, Windows 7 sees it as an old process and refuses to recognize it. I
need those date calculations, and I'm not thrilled with buying a later
version of Office - if it even is in the newer versions - because A) I don't
otherwise need it, and B) I've seen the recent version of Office and want no
part of it.
 
H

Hans Terkelsen

Help with scheduling issue said:
I finally entered the world of Windows 7, albeit only because my laptop died.
I am a historan who needs to calculate dates into the 18th century. Xdate
always worked just fine in Excel 2003, but when I load it into the new
computer, Windows 7 sees it as an old process and refuses to recognize it. I
need those date calculations, and I'm not thrilled with buying a later
version of Office - if it even is in the newer versions - because A) I don't
otherwise need it, and B) I've seen the recent version of Office and want no
part of it.

Remember also the 400 year trick.
400 gregorian years is a whole number of weeks,
so everything except easter repeats every 400 years.
To get the weekday for 1/1/1800 look at 1/1/2200 for example.

Hans T.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with XDATE function add-in 3
R.I.P. Windows 7 - What next ? 5
Windows 7 hardest hit by WannaCry worm 1
Windows 7 Win 7 Pro - XP 1
MX-19 a decent Windows 7 replacement. 2
Windows 7 Windows 7 reinstall 11
XP vs Windows 7 9
Adding months to a date 3

Top