Dear Biff, i have tried the formulas that u gave me...and finally it works
but counting the cells in red ( due date) and in orange ( 14 days within)

How bout i have other cells in other colour? like yellow, green, and cells
with no colour? are there any formula to do so which i can make it automatic
to count too? There contain no conditional formatting.....just manual fill in
colours...

Hope to hear from u real soon...
Thank You Biff....