"IF" multiple cells contain a Date then +1

[Jose Bug]

Need help with a formula that helps me do the following:

If any of the cells between G2 & G131 have dates then add 1 to E134
If any of the cells between L2 & L131 have dates then add 1 to E135

Thanks
jb

[Jose Bug]

so after a bit of googling I came up with the following:


If any of the cells between G2 & G131 have dates then add 1 to E134
=COUNTIF(G2:G131,">1/1/1900")

If any of the cells between L2 & L131 have dates then add 1 to E135
=COUNTIF(L2:L131,">1/1/1900")

[alansidman]

try this

Please Login or Register  to view this content.