| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date entered wrong or not as a date
Hi,
In Excel 2000, I am trying to enter a series of dates, say from july 1st 2005 to february 28, 2006. Excel does not recognize this as a date, in however form I enter it, even if I format the cell to force it to recognize a date. I have checked my regional settings, and updated them to use four-digit years as a default, but this does not help. Can anyone help? I need the worksheet to recognize a date and to be able to do calculations with it. Now, when I enter the date in a cell and do DAY(cell), I get a VALUE error. I suppose that means excel does not recognize the value in the cell as a date. Thanks for any help. Margo Guda. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
| cell assumes wrong date | Setting up and Configuration of Excel | |||
Threaded Mode
