| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Dates <Today?
Excel2003 ...
Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells. I wish Formula to return number of Dates <Todays Date (exclude other TEXT & EMPTY Cells) Thanks to the many that support these boards ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Dates <Today?
=countif(h7:dc7,"<"&today())
Ken wrote: Excel2003 ... Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells. I wish Formula to return number of Dates <Todays Date (exclude other TEXT & EMPTY Cells) Thanks to the many that support these boards ... Kha -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Dates <Today?
hi
assuming that you have real dates in your columns, try this =countif(H2:DC7,"<"&Today()) Regards FSt1 "Ken" wrote: Excel2003 ... Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells. I wish Formula to return number of Dates <Todays Date (exclude other TEXT & EMPTY Cells) Thanks to the many that support these boards ... Kha |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count Dates <Today?
Dave ... (Hi)
Before posting I tried several variations ... I would have been there if only I had remembered the "&" ... Thank you & the many others that offer so many solutions on these boards ... Kha "Dave Peterson" wrote: =countif(h7:dc7,"<"&today()) Ken wrote: Excel2003 ... Range H7:DC7 contains DATES (m/dd), TEXT & EMPTY Cells. I wish Formula to return number of Dates <Todays Date (exclude other TEXT & EMPTY Cells) Thanks to the many that support these boards ... Kha -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting dates before today | Excel Discussion (Misc queries) | |||
| count if gone past today | Excel Discussion (Misc queries) | |||
| Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
| Counting Dates less then today | Excel Worksheet Functions | |||
Linear Mode
