Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF, MONTH, YEAR
Hi there
I have a table of client data including the date that they first paid for services. I would like to summarise the information by counting the number of new clients per month (or, prefereably by week but I realise Excel doesn't have a WEEK formula) and returning the information in a new table with a list of months. It seems that the issue is in counting if the date from the client data table lies within the bounds of a particular month in a particular year. I have tried the MONTH and YEAR formulas but can't get them to work together while counting the number of times both are TRUE. Help would be very gratefully received! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Countif month & year | Excel Worksheet Functions | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel | |||
countif number of occurences per month per year. | Excel Worksheet Functions |