I have a spreadsheet that shows when the product was activated and then when the service warranty will expire. Sometimes the product is purchased without a service warranty, therefore, I have left that field blank. We started selling the product in 2007, however, our tracking did not begin until January of 2008. Therefore, I have used a countif statement to show activations in column c to be less than 2/1/08 for January 2008. When I go to service, I want it to count the number of units under service warranty during that date. I am using a formula of h2-countif(d:d),"<2/1/08".
This works great for the first few. However after a few months the numbers are not accurate in the service column I because it is counting everything that is less than the next month. However, some of those have expired and shouldn't be counted within that. Can someone help me with this please?
Thanks, Jake
http://www.mrexcel.com/forum/excel-q...ted-maybe.html
Bookmarks