View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Sullentrup Bob Sullentrup is offline
external usenet poster
 
Posts: 25
Default 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