Date Functions in Excel

[Paul]

I would really like more date/time options in Excel. Go look at what Matlab
provides. Some suggestions:
- provide an option on the DATEVALUE function where the epoch (start date)
is provided by the user. Matlab default is 1-Jan-0000.
- provide an option for DATEVALUE function to specify the time of the epoch
like 12:00:00 or something like this.
- It would be great if there were canned functions to calculate number of
days since the J2000 epoch or other common epochs.
- It would be great if there were canned functions to translate the current
time or a provided time into J2000 or a time relative to a provided epoch.
- It would be helpful if the date and time functions would provide some more
functions that allow input of date and time together and calculate the serial
number of days

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Peo Sjoblom]

I would really like more date/time options in Excel. Go look at what
Matlab
provides. Some suggestions:
- provide an option on the DATEVALUE function where the epoch (start date)
is provided by the user. Matlab default is 1-Jan-0000.
- provide an option for DATEVALUE function to specify the time of the
epoch
like 12:00:00 or something like this.
- It would be great if there were canned functions to calculate number of
days since the J2000 epoch or other common epochs.
- It would be great if there were canned functions to translate the
current
time or a provided time into J2000 or a time relative to a provided epoch.
- It would be helpful if the date and time functions would provide some
more
functions that allow input of date and time together and calculate the
serial
number of days

The DATEVALUE function does nothing but convert a text expression into a
serial number date.
If MS changed the date system it would probably destroy millions of
workbooks. Are you saying that you cannot put date and time together in
Excel or that you cannot count the serial number of days?



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey