How do I create a formula in Excel to generate the date?

Answer by  system1 (7)

First select column which u want to generate the date and click the f2 button, the cursor blinked in the corrent cell and then press the "=" symbol in to the cell and type Date(year,month,day) which is u want to generate the date like =Day(2009,08,14),the output of date is 8/14/2009

Answer by  Aleksandr (45)

If you want to generate a record of date format from numbers representing year, month and day,enter DATE(yyyy,mm,dd) where yyyy - year or reference to cell with year, mm - month, dd - day (or corresponding cells). If you want to generate current date, enter NOW().

Answer by  Snappledrank (103)

You need to use the NOW() function. Select the field where you want the date to appear, and enter NOW() in that field. It should generate the current date in that field. You can also click the "Formulas" tab, click on "Date and Time" under the Function Library, then click on "DATE"

Answer by  manimanakody (28)

Select the cell - Type the formula as =DATE( - enter the year - Press comma key (,) - enter the month - Press the comma key (,) - enter the day - Close the formula by entering the closing bracket ).

Answer by  durgesh (12)

Use the date function in the formula Eg : =DATE() give '=DATE()' in the the formula and input parameters values year = 2009; month =11 day = 5 will give date 11/5/2009 in the cell OR give directly =DATE(2009,11,5) will give date 11/5/2009 in the cell

Answer by  gigo (1706)

You have two possibilities: Either you use the worksheet functions or the vba functions. With the worksheet function use DATE(), with VBA use Date or CDate.