Insert current date in excel. RRS feed

  • Question

  • User-977583538 posted


    I am making windows application in C#.net where i have to generate one formatted excel sheet.

    So that i want some formula to insert current date which i can use in my source code

    I have five columns in excel:

    Name      Date      Status       StartTime       EndTime


    If user insert name in cell of name column then current date should be automatically inserted in cell of date column same as with starttime.

    I do not want to use =TODAY() as this would change the date, daily,

    Tuesday, August 30, 2011 3:39 AM

All replies

  • User-791160327 posted

    use System.DateTime.Now;

    u will get date &  time  also.

    Tuesday, August 30, 2011 4:17 AM