| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
counting specified date entries
Hi,
Please can someone advise me on the formula I require for this problem. I would like to calculate the number of dates in a specified column, that is equal to the current date or the date has passed. Any suggestion will be greatly appreciated |
|
#2
|
|||
|
|||
|
=COUNTIF($A$2:$A$15,"<="&F2) would count dates in A2:A15 less than or equal to the date in F2, with which they are compared. dave Wrote: Hi, Please can someone advise me on the formula I require for this problem. I would like to calculate the number of dates in a specified column, that is equal to the current date or the date has passed. Any suggestion will be greatly appreciated -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=277159 |
|
#3
|
|||
|
|||
|
Many Thanks
"Aladin Akyurek" wrote: =COUNTIF($A$2:$A$15,"<="&F2) would count dates in A2:A15 less than or equal to the date in F2, with which they are compared. dave Wrote: Hi, Please can someone advise me on the formula I require for this problem. I would like to calculate the number of dates in a specified column, that is equal to the current date or the date has passed. Any suggestion will be greatly appreciated -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=277159 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting non occur entries | Excel Discussion (Misc queries) | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
| counting entries between two dates? | Excel Worksheet Functions | |||
Linear Mode
