I need help using countifs formula to identify a date within the next 90 days. I have tried everything but for some reason nothing is working!
In column C I need to count the dates between columns F & N that are within the next 90 days. I know these dates as they are highlighted in orange using conditional formatting. But every formula I try gives me every other number but 1.
I thought maybe it was counting the dates overdue (in red) too but I'm so confused - please help!
Is this a Google sheets question or an Excel question? Excel Sheets (Google Chrome) sounds like some ghastly hybrid.
Please amend your profile to show the Excel PRODUCT you are using ... or Google sheets, as appropriate.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Maybe:
=SUMPRODUCT((N(+'SWAPP Training Matrix'!F2:N2)>TODAY())*(N(+'SWAPP Training Matrix'!F2:N2)<TODAY()+90))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks