Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LOOKUP and COUNTIF
hi all,
i wonder if anyone can help me with a formula i want to create. in column A i have names of products, and in column B i have the date (sell by date, for example). how can i create a formula to count the number of a specific product that has a data equal or above the current date (or a specific date)? e.g. count the number of bananas that have a date greater or equal than todays's date (18/01/05) = 2 A B Bananas 01/04/05 Apples 05/06/05 Apples 28/02/05 Oranges 04/03/05 Bananas 14/01/05 Bananas 22/02/05 Apples 16/01/05 ps: these dates are in uk format - dd/mm/yy !! thanks to anyone who can help |