| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match date to today
Hi All
need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match date to today
If the dates in ColA are in excel date format the below would work...
=COUNTIF(A:A,TODAY()) If this post helps click Yes --------------- Jacob Skaria "Derek M" wrote: Hi All need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match date to today
I think you have helped me before, and it worked again, thank you so much,
you are a genuis :) Derek "Jacob Skaria" wrote: If the dates in ColA are in excel date format the below would work... =COUNTIF(A:A,TODAY()) If this post helps click Yes --------------- Jacob Skaria "Derek M" wrote: Hi All need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match date to today
Ooh just one other thing if i may, what if i also wanted to reference another
column to filter out just one word i.e. match the date to today, but also check another column for the word "mymail" and bring just those results back (count mymail under todays date) Thanks again Derek "Derek M" wrote: I think you have helped me before, and it worked again, thank you so much, you are a genuis :) Derek "Jacob Skaria" wrote: If the dates in ColA are in excel date format the below would work... =COUNTIF(A:A,TODAY()) If this post helps click Yes --------------- Jacob Skaria "Derek M" wrote: Hi All need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match date to today
When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2)) =SUMPRODUCT((A1:A10=TODAY())*(B1:B10="mymail")) If you are using XL2007; check out help on COUNTIFS() If this post helps click Yes --------------- Jacob Skaria "Derek M" wrote: Ooh just one other thing if i may, what if i also wanted to reference another column to filter out just one word i.e. match the date to today, but also check another column for the word "mymail" and bring just those results back (count mymail under todays date) Thanks again Derek "Derek M" wrote: I think you have helped me before, and it worked again, thank you so much, you are a genuis :) Derek "Jacob Skaria" wrote: If the dates in ColA are in excel date format the below would work... =COUNTIF(A:A,TODAY()) If this post helps click Yes --------------- Jacob Skaria "Derek M" wrote: Hi All need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match date to today
Thanks for your help again, i veru much appreciate it, i am learning all the
time too "Derek M" wrote: Hi All need to match dates in a column of data to todays date, i.e. 3/11/09 4/11/09 5/11/09 5/11/09 If today is 5/11/09 then the cell would return the value 2, i cant figure out the sum :) Thanks for any help in advance Derek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date in excel from today to original date of file | Excel Discussion (Misc queries) | |||
| Date Formula for number of days between a date and today | Excel Discussion (Misc queries) | |||
| IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
![Derek M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
