| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating overdue date fields
Perfect, that formula worked. Thanks so much!!
Bernard Liengme wrote: =COUNTIF(B:B,"<"&A1)+COUNTIF(B:B,"TBD") Excel may try to be helpful and display the answer as 3 Jan 1900 - just format the cell with the formula as General best wishes I have a column with dates that I'd like to use a count formula where it counts the total number of rows that are past a certain date. How [quoted text clipped - 58 lines] date criteria and "TBD"? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200812/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highlight cell with colour if date overdue | New Users to Excel | |||
| how do I calculate 30, 60 90 days overdue from date invoiced | Excel Discussion (Misc queries) | |||
| Can I group overdue Invoices by date from an Excel worksheet? | Excel Worksheet Functions | |||
| need an overdue date to highlight | Excel Discussion (Misc queries) | |||
| Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
Threaded Mode
