| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date without true value
Hi,
I have a table that lists the invoice dates. On a monthly basis, I need to write a report of how many invoices were issue, let's say, in January. I converted the date mm/dd/yy into just mm/yy, but I still have the true value in the background and when I try to count how many invoices were issued in January, I get "0". Any suggestion? Thank you for your help. Rubem |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a date that does not update if a condition is true | Excel Worksheet Functions | |||
| convert a text date to a true date | Excel Discussion (Misc queries) | |||
| return TRUE if a date falls between two dates | Excel Worksheet Functions | |||
| If Function Value if true = Date +30days | Excel Discussion (Misc queries) | |||
| Need true or false if a date falls between a date range | Excel Worksheet Functions | |||
Threaded Mode
