cjgrafixdesign
New Member
- Joined
- Feb 7, 2019
- Messages
- 2
HELP :D
I'm building a formula that would find between two dates and SUM which if found this on your site very useful formula
=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64)
The formula helps me find all the dates I needed to count within certain worksheets.
for example I have this
START DATE (OCTOBER 1, 2018)
END DATE (OCTOBER 31, 2018)
Within 12 worksheet it did find all dates between October 1 to October 31.
however, i'd like to ask if .. it is possible for a formula that aside from finding those dates between. is it possible to have it SUM/DIFF into another date and it will only COUNTIF if it is greater than 3.
example data:
<tbody>
</tbody>
=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64) NOTE: not the actual cell num
using the above formula will find the October, using column DATE PROCESS....after finding the date is it possible to also test C-B (as long as it is under October) and will only display a value greater than 3 days
sorry for my first post newbies here :D
I'm building a formula that would find between two dates and SUM which if found this on your site very useful formula
=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64)
The formula helps me find all the dates I needed to count within certain worksheets.
for example I have this
START DATE (OCTOBER 1, 2018)
END DATE (OCTOBER 31, 2018)
Within 12 worksheet it did find all dates between October 1 to October 31.
however, i'd like to ask if .. it is possible for a formula that aside from finding those dates between. is it possible to have it SUM/DIFF into another date and it will only COUNTIF if it is greater than 3.
example data:
A<strike></strike> | B<strike></strike> | C <strike></strike> |
DESCRIPTION<strike></strike> | DATE FILE <strike></strike> | DATE PROCESS <strike></strike> |
APPLE <strike></strike> | 10/05/2018 <strike></strike> | 10/10/2018 <strike></strike> |
GRAPES<strike></strike> | 11/05/2018 <strike></strike> | 11/10/2018 <strike></strike> |
ORANGE<strike></strike> | 12/05/2018 | 12/05/2018 <strike></strike> |
<tbody>
</tbody>
=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64) NOTE: not the actual cell num
using the above formula will find the October, using column DATE PROCESS....after finding the date is it possible to also test C-B (as long as it is under October) and will only display a value greater than 3 days
sorry for my first post newbies here :D