| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNT - date as a field only works when entered as a number
I am using Windows 2007. In my database, the date (month and year) is a
column header. In the formula, if I enter the field in "" as "10/1/2009", or "Oct-09", I get #VALUE!. However, if I enter the field as "40087", the formula returns the correct result. Has anyone come up with this and know a way around? I can come up with the number equivalent of each date, but since I am not the end user of this file, it would be easier to be able to enter the date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to set up a number based on date entered | Excel Discussion (Misc queries) | |||
| Sumproduct based on date entered in separate field | Excel Discussion (Misc queries) | |||
| LIMIT THE NUMBER OF CHARACTERS ENTERED IN A FIELD | Excel Worksheet Functions | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| Date Entered +7, unless another field is greater than 0 | Excel Worksheet Functions | |||
Threaded Mode
