Count Format with date range

[Arun Mani A]

Hi,

I am working on a sheet which has dates, formatted with 2 colours and 2 different borders. I got VBA function to count the cells with similar border and fill. I need to count also the nos of dates in particular month which is filled with green and yellow border.

Attached is the excel file.

Thanks in advance

 

[NARAYANK991]

Hi ,

See if this works.

Narayan

 

[Arun Mani A]

Dear Narayan,

Thanks a lot. It's working well.