Hi guys,
Just a quick one i've been meddling with to not much success - i have the following formula that checks how many dates are ending in the next 60 days: =countif(AH:AH,"<="&today()+60)
How would i amend this so it checks how many dates are ending in between the next 30 and 60 days only? (rather than the whole 60 days?)
Any help much appreciated
Abs
Hi,
Instead of the COUNTIF() function use the COUNTIFS() instead. e.g.
Formula:
Please Login or Register to view this content.
It probably doesn't matter too much here but try and get into the habit of only using ranges that contain data rather than whole columns. Use dynamic range names where data may be expanding or contracting.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Great thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks