| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count days
Column A is a list of dates, and I only want to count the dates that are
older (or younger) than today. I want to compare against the system date, so the count is dynamic depending on the day the data is accessed. Also, in column B I have attributes Q or Z. I only want the date total for rows containing Q, ignoring rows with Z. I tried the following with no success. Open is the name of the spreadsheet within the workbook, that contains the data. =SUM(IF(Open!$B$3:$B$296="Q",IF(Open!$A$3:$A$296," "&TODAY,1,0),0) Thanks. --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count distinct days from two groups of days | Excel Worksheet Functions | |||
| Count Days more than 180 days prior to today | Excel Worksheet Functions | |||
| When word says Install I want it count the days for 3 days w.o wee | Excel Worksheet Functions | |||
| COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
| Count of days | Excel Worksheet Functions | |||
Threaded Mode
