Trying to add a date range to select dates from ideal would like calander to show when click in to and from cells

[censura]

Hi, so i have this formula that works fine
=COUNTIF(leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only")

I have added to cells A13 & B13 to add from to dates and tried to see if i could get formula to work but just couldn't get it to work if one of you great guys can it would be really great. This was my attempt


=COUNTIF(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))>=$A$13)*(((leads!AD2:AD2224,"Loan Plus Accountancy") + COUNTIF(leads!$AD$2:$AD$2224,"Loan Only"))<=$B$13)

The 2nd part is then on click of cell opens calendar to choose dates from

Thank you

 

[censura]

Dont worry about calendar part i solved that thank you

 

[Fluff]

Duplicate to: Add date range using From & To cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.