Change Excel Date Format using C#
Hi,
I am just wondering how I can change the Excel Date Format using C#.
I declared the date as string like "1-Apr-09" and I know it shows 39,904 if I change the format cell in excel.
How do I do that using C#? Please refer to the code below. Could anyone please implement
double DateChangeToDouble(string a) below? Thank you so much.
Class Program
{
double DateChangeToDouble(string a)
{
double b;
// Implementing a to change to double value here
return b;
}
static void Main(string[] args)
{
string a = "1-Apr-09";
double b = DateChangeToDouble(a); //double b should be 39904 here.
Console.WriteLine(b); //39904
}
}