| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get less than dates if Data in another column equals data
Try this:
=SUMPRODUCT((B1:B100<=DATE(2008,7,31)) I've assumed your dates are in B1:B100 - adjust to suit. Hope this helps. Pete On Nov 16, 7:18 pm, Dan Soleau <Dan wrote: I have two columns. One contains general contractor names the other contains dates from current until december of 2008. I want to create an updating formula to count how many dates are less than or equal too 7/31/08 for each contractor. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum data in column for dates until today | Excel Worksheet Functions | |||
| How do I Fill a column with dates (for 3 years of daily data) | Excel Discussion (Misc queries) | |||
| Using a range of dates to add data in a different column? | Excel Worksheet Functions | |||
| Using a range of dates to add data in a different column? | Excel Worksheet Functions | |||
| Adding Column of mixed data omitting the dates | Excel Discussion (Misc queries) | |||
Threaded Mode
