Counting License Plates
Posted by Dallas on July 24, 2001 2:13 PM
Out of a list of license plates I want to count how many are rentals and that have been paid after 14 days. There are also fields that have no value in the amount of days column so I had to subtract them from the total. License plates are LLL### (L=Letter)and rentals are L#####. This is my formula that I came up with.
I think my problem is the and but I'm not sure what to use.