M
majestyk
I need to count the number of occurences of a range of dates eg from 1st to
31st of a given month OR set a criteria to count the occurences between 2
dates eg 1/3/08 to 7/3/08 inclusive. The named range is set to presentations
and i have tried countif/sumif and conditional sum wizard yet to no avail.
What I have come close with, but still gives a wrong answer:
=COUNTIF(Presentations,AND(">="&"01 Mar 08","<="&"31 Mar 08"))
any help appreciated (dates are dd/mm/yy in Australia)
31st of a given month OR set a criteria to count the occurences between 2
dates eg 1/3/08 to 7/3/08 inclusive. The named range is set to presentations
and i have tried countif/sumif and conditional sum wizard yet to no avail.
What I have come close with, but still gives a wrong answer:
=COUNTIF(Presentations,AND(">="&"01 Mar 08","<="&"31 Mar 08"))
any help appreciated (dates are dd/mm/yy in Australia)