A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

xdate in Windows 7



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2010, 01:47 AM posted to microsoft.public.excel.worksheet.functions
Help with scheduling issue
external usenet poster
 
Posts: 1
Default xdate in Windows 7

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.
  #2  
Old June 6th, 2010, 02:07 AM posted to microsoft.public.excel.worksheet.functions
Dave Peterson
external usenet poster
 
Posts: 19,791
Default xdate in Windows 7

I bet you were using an addin by John Walkenbach:
http://j-walk.com/ss/excel/files/xdate.htm



Help with scheduling issue wrote:

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.


--

Dave Peterson
  #3  
Old June 6th, 2010, 11:01 AM posted to microsoft.public.excel.worksheet.functions
Hans Terkelsen
external usenet poster
 
Posts: 28
Default xdate in Windows 7


"Help with scheduling issue" wrote in message
...
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.