Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 31
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want all windows in one excel frame (windows in taskbar) Subramanya Excel Discussion (Misc queries) 1 December 18th 09 03:14 PM
cannot open exel from windows xp in windows vista and visa versa lildiana New Users to Excel 4 February 25th 09 07:26 PM
Help with XDATE function add-in Mary[_5_] Excel Worksheet Functions 3 June 22nd 08 04:52 PM
can windows vista edit shared document from windows xp sasa Excel Worksheet Functions 1 January 9th 08 06:44 PM
Page breaks are different in Windows 2000 and Windows XP Bill Allen Excel Discussion (Misc queries) 1 November 23rd 05 04:42 PM


All times are GMT +1. The time now is 08:23 AM.

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

About Us

"It's about Microsoft Excel"