Posted to microsoft.public.excel.programming

Bob Sullentrup Bob Sullentrup is offline

external usenet poster

Posts: 25

VSTO Date Evaluation

Folks,

I have a cell (F8) containing 7/14/2005, which translates to 38547 in the C#
code-behind.

I can translate 38547 to 7/14/2005 with the following:

day_to_process =
(Convert.ToDateTime("12/30/1899")).AddDays(Convert.ToDouble(((Excel.Range)rng Lookup.Cells[8,6]).Value2.ToString()));

Anybody have a better way?

--
Bob Sullentrup

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel Function - Date evaluation	bigbird98	Excel Worksheet Functions	2	July 23rd 08 08:27 PM
VSTO	David12345	Excel Discussion (Misc queries)	2	December 27th 05 08:14 PM
Function with VSTO ?	[email protected]	Excel Programming	1	August 29th 05 02:17 AM
VBA, UDFs and VSTO	Terence Craig	Excel Programming	3	October 25th 04 07:57 AM
VSTO 2.0	No Name	Excel Programming	1	December 8th 03 09:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us