Hi, I want to count the number of dates in a column that are greater than TODAY - Simple but I want this based on the date in another column so if the dates in column A fall in Jan then count the dates greater than today in column B and so on for Feb/Mar etc.
I have attached a sheet with my current thinking on but this does not seem to work
=COUNTIFS($A$2:$A$85,">="&$F2,$A$2:$A$85,"<"&EDATE($F2,1),$B$2:$B$85,"<=today()")
any assistance greatly appreciated Dates are not my strong point!
Thanks
Syntax!
Try this:
=COUNTIFS($A$2:$A$85,">="&$F2,$A$2:$A$85,"<"&EDATE($F2,1),$B$2:$B$85,"<="&TODAY())
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
PerhapsFormula:
Please Login or Register to view this content.
Last edited by Pepe Le Mokko; 04-21-2022 at 09:34 AM.
Hi AliG thanks for the suggestion but I can't get this to work? it counts 31 for Jan and 23 for Feb when it should be counting 1 for Jan and 2 for Feb? I have included updated sheet to demonstrate in column G
Thanks Pepe Le Mokko - I am not sure if I am doing something wrong but I get the same result for each - I have added this in column H to demonstrate
thanks
Syntax again!
If you want GREATER THAN TODAY:
=COUNTIFS($A$2:$A$85,">="&$F2,$A$2:$A$85,"<"&EDATE($F2,1),$B$2:$B$85,">"&TODAY())
ahhh Thanks AliG I ma always getting those two pesky lil >< the wrong way round! this works perfectly thank you!
Remember it like this:
E2>6 - E2 is bigger than six because the wide part of the funnel is against E2.
E2<6 - E2 is smaller than six because the point of the funnel is against E2.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
By the way, my user name here is AliGW. not AliG.
Thanks AliGW, Apologies on the incorrect name, trying to do to many things at once.
I have marked as solved and added reputation. thank you for your assistance
You're welcome. You can use Ali, as that is my name, or AliGW, my user name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks