Spreadsheet: 90665d1290450220-using-if-and-or-excel-forum-copy
Sheet: Sheet1

W/E | Report# | Payment Received | Current Billing Status
2010-01-05 00:00:00 | RR1314 | 2010-05-08 00:00:00
2010-01-05 00:00:00 | RR1315 | 2010-04-13 00:00:00
2010-01-05 00:00:00 | RR1316 | 2010-02-22 00:00:00
2010-01-06 00:00:00 | RR1317 | 2010-02-22 00:00:00
2010-01-06 00:00:00 | RR1318 | 2010-02-22 00:00:00
2010-01-06 00:00:00 | RR1319 | 2010-04-13 00:00:00
2010-01-07 00:00:00 | RR1320 | 2010-05-08 00:00:00
2010-01-07 00:00:00 | RR1321
2010-01-07 00:00:00 | RR1322 | 2010-05-08 00:00:00
2009-01-07 00:00:00 | RR1323 | 2010-04-13 00:00:00
2010-01-09 00:00:00 | RR1324 | 2010-04-13 00:00:00
2010-01-11 00:00:00 | RR1325 | 2010-02-27 00:00:00
2010-01-11 00:00:00 | RR1326 | 2010-04-13 00:00:00
2010-01-14 00:00:00 | RR1327 | 2010-04-13 00:00:00
2010-01-15 00:00:00 | RR1328 | 2010-04-13 00:00:00
2010-01-20 00:00:00 | RR1329 | 2010-06-07 00:00:00
2010-01-20 00:00:00 | RR1330 | 2010-06-21 00:00:00
2009-01-21 00:00:00 | RR1331 | 2010-03-31 00:00:00
2010-01-21 00:00:00 | RR1332 | 2010-04-13 00:00:00
2010-01-21 00:00:00 | RR1333 | 2010-03-25 00:00:00
2010-01-22 00:00:00 | RR1334
2010-01-27 00:00:00 | RR1335 | 2010-06-07 00:00:00
2010-01-27 00:00:00 | RR1336 | 2010-04-13 00:00:00
2010-01-28 00:00:00 | RR1337 | 2010-04-13 00:00:00
2010-01-29 00:00:00 | RR1338 | 2010-04-13 00:00:00
2010-02-02 00:00:00 | RR1339
2010-02-03 00:00:00 | RR1340 | 2010-04-13 00:00:00
2010-02-03 00:00:00 | RR1341 | 2010-05-22 00:00:00
2010-02-03 00:00:00 | RR1342 | 2010-06-14 00:00:00
2010-02-04 00:00:00 | RR1343 | 2010-04-13 00:00:00
2010-02-09 00:00:00 | RR1344 | 2010-04-13 00:00:00
2010-02-11 00:00:00 | RR1345 | 2010-04-13 00:00:00
2010-02-11 00:00:00 | RR1346 | 2010-04-25 00:00:00
2010-02-12 00:00:00 | RR1347 | 2010-04-25 00:00:00
2010-02-15 00:00:00 | RR1348 | 2010-04-25 00:00:00
2010-02-16 00:00:00 | RR1349 | 2010-04-25 00:00:00
2010-02-16 00:00:00 | RR1350 | 2010-04-25 00:00:00
2010-02-16 00:00:00 | RR1351 | 2010-04-10 00:00:00
2010-02-18 00:00:00 | RR1352 | 2010-04-25 00:00:00
2010-03-08 00:00:00 | [NAME] | 2010-05-24 00:00:00
2010-02-22 00:00:00 | RR1354 | 2010-04-25 00:00:00
2010-02-23 00:00:00 | RR1355 | 2010-04-13 00:00:00
2010-02-24 00:00:00 | RR1356 | 2010-05-22 00:00:00
2010-02-27 00:00:00 | RR1357 | 2010-04-25 00:00:00
2010-02-27 00:00:00 | RR1358 | 2010-06-21 00:00:00
2010-03-01 00:00:00 | RR1359 | 2010-05-22 00:00:00
2010-03-07 00:00:00 | REL1360
2010-03-07 00:00:00 | REL1361
2010-03-07 00:00:00 | REL1362 | 2010-08-16 00:00:00
2010-02-23 00:00:00 | REL1363
 | RR1364
 | RR1365
2010-03-02 00:00:00 | RR1366
2010-03-17 00:00:00 | RR1367
2010-03-19 00:00:00 | RR1368
 | RR1369
2010-03-01 00:00:00 | RR1370 | 2010-06-07 00:00:00
2010-03-03 00:00:00 | RR1371 | 2010-05-08 00:00:00
2010-03-03 00:00:00 | RR1372 | 2010-05-08 00:00:00
2010-03-03 00:00:00 | RR1373 | 2010-05-08 00:00:00
2010-03-03 00:00:00 | RR1374 | 2010-06-14 00:00:00
2010-03-04 00:00:00 | RR1375 | 2010-05-08 00:00:00
2010-03-04 00:00:00 | RR1376 | 2010-05-08 00:00:00
2010-03-05 00:00:00 | RR1377 | 2010-06-06 00:00:00
2010-03-05 00:00:00 | RR1378 | 2010-05-08 00:00:00
2010-03-05 00:00:00 | RR1379 | 2010-06-21 00:00:00
2010-03-26 00:00:00 | RR1380
 | RR1381
 | RR1382
 | RR1383
2010-04-09 00:00:00 | RR1384 | 2010-05-24 00:00:00
2010-04-12 00:00:00 | [NAME]
2010-04-13 00:00:00 | REL1386
2010-04-28 00:00:00 | REL1387
2010-04-14 00:00:00 | RR1388
2010-04-26 00:00:00 | REL1389
2010-03-09 00:00:00 | RR1390 | 2010-03-16 00:00:00
2010-03-09 00:00:00 | RR1391 | 2010-06-21 00:00:00
2010-03-15 00:00:00 | RR1392 | 2010-04-13 00:00:00
2010-03-19 00:00:00 | RR1393 | 2010-05-03 00:00:00
2010-03-19 00:00:00 | RR1394 | 2010-05-03 00:00:00
2010-03-19 00:00:00 | RR1395 | 2010-05-03 00:00:00
2010-03-19 00:00:00 | RR1396 | 2010-05-03 00:00:00
2010-03-22 00:00:00 | RR1397 | 2010-06-21 00:00:00
2010-03-22 00:00:00 | RR1398 | 2010-07-01 00:00:00
2010-03-22 00:00:00 | RR1399 | 2010-07-01 00:00:00
2010-03-23 00:00:00 | RR1400 | 2010-05-22 00:00:00
2010-03-24 00:00:00 | RR1401 | 2010-05-13 00:00:00
2010-03-24 00:00:00 | RR1402 | 2010-05-08 00:00:00
2010-03-26 00:00:00 | RR1403 | 2010-07-07 00:00:00
2010-03-30 00:00:00 | RR1404 | 2010-07-01 00:00:00
2010-03-30 00:00:00 | RR1405 | 2010-07-01 00:00:00
2010-03-30 00:00:00 | RR1406 | 2010-06-03 00:00:00
2010-04-01 00:00:00 | RR1407 | 2010-05-16 00:00:00
2010-01-20 00:00:00 | RR1408 | 2010-02-13 00:00:00
2010-03-29 00:00:00 | RR1409 | 2010-04-06 00:00:00
2010-04-05 00:00:00 | RR1410 | 2010-05-24 00:00:00
2010-04-06 00:00:00 | RR1411 | 2010-05-24 00:00:00
2010-04-07 00:00:00 | RR1412 | 2010-05-24 00:00:00
2010-04-09 00:00:00 | RR1413 | 2010-05-22 00:00:00
2010-04-09 00:00:00 | RR1414 | 2010-07-07 00:00:00
2010-04-12 00:00:00 | RR1415 | 2010-07-07 00:00:00
2010-04-13 00:00:00 | RR1416 | 2010-07-19 00:00:00
2010-04-13 00:00:00 | RR1417 | 2010-05-24 00:00:00
2010-04-13 00:00:00 | RR1418 | 2010-07-12 00:00:00
2010-04-14 00:00:00 | RR1419 | 2010-06-21 00:00:00
2010-04-23 00:00:00 | REL1420
2010-04-23 00:00:00 | REL1421
2010-04-27 00:00:00 | REL1422
2010-04-27 00:00:00 | REL1423
2010-04-28 00:00:00 | REL1424
 | REL1425
2010-04-29 00:00:00 | RR1426 | 2010-06-06 00:00:00
2010-05-03 00:00:00 | REL1427
2010-05-12 00:00:00 | RR1428
2010-05-16 00:00:00 | REL1429
2010-04-15 00:00:00 | RR1430 | 2010-06-06 00:00:00
2010-04-16 00:00:00 | RR1431 | 2010-07-12 00:00:00
2010-04-21 00:00:00 | RR1432 | 2010-07-07 00:00:00
2010-04-21 00:00:00 | RR1433 | 2010-07-12 00:00:00
2010-04-23 00:00:00 | RR1434 | 2010-06-26 00:00:00
2010-04-23 00:00:00 | RR1435 | 2010-06-12 00:00:00
2010-04-23 00:00:00 | RR1436 | 2010-07-12 00:00:00
2010-04-28 00:00:00 | RR1437 | 2010-06-26 00:00:00
2010-04-28 00:00:00 | RR1438 | 2010-06-26 00:00:00
2010-04-29 00:00:00 | RR1439 | 2010-06-26 00:00:00
2010-04-29 00:00:00 | RR1440 | See Notes
2010-04-30 00:00:00 | RR1441 | See Notes
2010-05-03 00:00:00 | RR1442 | 2010-06-21 00:00:00
2010-05-04 00:00:00 | RR1443 | 2010-07-19 00:00:00
2010-05-04 00:00:00 | RR1444 | 2010-07-12 00:00:00
2010-05-05 00:00:00 | RR1445 | 2010-07-07 00:00:00
2010-05-05 00:00:00 | RR1446 | 2010-07-03 00:00:00
2010-05-07 00:00:00 | RR1447 | 2010-06-21 00:00:00
2010-05-11 00:00:00 | RR1448 | 2010-07-03 00:00:00
2010-05-11 00:00:00 | RR1449 | 2010-07-12 00:00:00
2010-05-20 00:00:00 | 1450
2010-05-20 00:00:00 | REL1451
2010-05-24 00:00:00 | RR1452 | 2010-07-19 00:00:00
2010-05-28 00:00:00 | RR1453
2010-05-29 00:00:00 | REL1454
2010-06-04 00:00:00 | REL1455
2010-06-09 00:00:00 | RR1456 | 2010-07-13 00:00:00
2010-06-13 00:00:00 | RR1457
2010-06-15 00:00:00 | REL1458
2010-06-23 00:00:00 | REL1459
2010-05-11 00:00:00 | RR1460 | 2010-07-12 00:00:00
2010-05-13 00:00:00 | RR1461 | See Notes
2010-05-13 00:00:00 | RR1462 | 2010-07-26 00:00:00
2010-05-14 00:00:00 | RR1463 | 2010-06-26 00:00:00
2010-05-15 00:00:00 | RR1464 | 2010-07-03 00:00:00
2010-04-21 00:00:00 | RR1465 | 2010-08-16 00:00:00
2010-05-17 00:00:00 | RR1466 | 2010-07-03 00:00:00
2010-05-18 00:00:00 | RR1467 | 2010-07-03 00:00:00
2010-05-20 00:00:00 | RR1468 | 2010-07-03 00:00:00
2010-05-20 00:00:00 | RR1469 | 2010-09-10 00:00:00
2010-05-25 00:00:00 | RR1470 | 2010-09-15 00:00:00
2010-05-26 00:00:00 | RR1471 | 2010-09-20 00:00:00
2010-06-01 00:00:00 | RR1472 | 2010-07-19 00:00:00
2010-06-01 00:00:00 | RR1473 | 2010-09-23 00:00:00
2010-06-02 00:00:00 | RR1474 | 2010-09-23 00:00:00
2010-06-03 00:00:00 | RR1475 | 2010-07-26 00:00:00
2010-06-04 00:00:00 | RR1476
2010-06-04 00:00:00 | RR1477 | 2010-08-21 00:00:00
2010-06-04 00:00:00 | RR1478 | See Notes
2010-06-07 00:00:00 | RR1479 | 2010-08-20 00:00:00
2010-06-25 00:00:00 | RR1480 | 2010-08-28 00:00:00
2010-06-30 00:00:00 | RR1481 | 2010-08-02 00:00:00
2010-07-08 00:00:00 | REL1482
2010-07-13 00:00:00 | RR1483
2010-07-22 00:00:00 | RR1484 | 2010-08-20 00:00:00
 | 1485
 | 1486
2010-08-08 00:00:00 | RR1487
2010-08-13 00:00:00 | RR1488 | See Notes
2010-08-17 00:00:00 | REL1489
2010-06-07 00:00:00 | RR1490
2010-06-08 00:00:00 | RR1491 | 2010-07-26 00:00:00
2010-06-08 00:00:00 | RR1492 | 2010-08-20 00:00:00
2010-06-09 00:00:00 | RR1493 | 2010-09-23 00:00:00
2010-06-10 00:00:00 | RR1494 | 2010-07-26 00:00:00
2010-06-11 00:00:00 | RR1495 | 2010-07-26 00:00:00
2010-06-11 00:00:00 | RR1496 | 2010-09-01 00:00:00
2010-06-11 00:00:00 | RR1497 | 2010-08-21 00:00:00
2010-06-11 00:00:00 | RR1498 | See Notes
2010-06-14 00:00:00 | RR1499 | 2010-09-23 00:00:00
2010-06-15 00:00:00 | RR1500 | 2010-09-01 00:00:00
2010-06-15 00:00:00 | RR1501
2010-06-15 00:00:00 | RR1502 | 2010-08-16 00:00:00
2010-06-16 00:00:00 | RR1503 | 2010-09-23 00:00:00
2010-06-17 00:00:00 | RR1504 | 2010-08-30 00:00:00
2010-06-18 00:00:00 | RR1505 | 2010-09-23 00:00:00
2010-06-18 00:00:00 | RR1506
2010-06-21 00:00:00 | RR1507
2010-06-22 00:00:00 | RR1508
2010-06-22 00:00:00 | RR1509 | See Notes
2010-06-22 00:00:00 | RR1510 | 2010-09-23 00:00:00
2010-06-23 00:00:00 | RR1511 | See Notes
2010-06-28 00:00:00 | RR1512 | 2010-08-09 00:00:00
2010-06-29 00:00:00 | RR1513 | See Notes
2010-06-30 00:00:00 | RR1514 | 2010-09-23 00:00:00
2010-07-01 00:00:00 | RR1515
2010-07-01 00:00:00 | RR1516
2010-07-06 00:00:00 | RR1517
2010-07-06 00:00:00 | RR1518 | See Notes
2010-07-06 00:00:00 | RR1519 | 2010-08-21 00:00:00
2010-07-06 00:00:00 | RR1520
2010-07-07 00:00:00 | RR1521 | 2010-08-21 00:00:00
2010-07-08 00:00:00 | RR1522 | 2010-09-12 00:00:00
2010-07-08 00:00:00 | RR1523 | 2010-08-21 00:00:00
2010-07-09 00:00:00 | RR1524 | 2010-09-17 00:00:00
2010-07-14 00:00:00 | RR1525
2010-07-15 00:00:00 | RR1526
2010-07-16 00:00:00 | RR1527 | 2010-09-01 00:00:00
2010-07-16 00:00:00 | RR1528
2010-07-19 00:00:00 | RR1529 | See Notes
2010-07-19 00:00:00 | RR1530
2010-07-20 00:00:00 | RR1531 | 2010-08-09 00:00:00
2010-07-20 00:00:00 | RR1532
2010-07-21 00:00:00 | RR1533 | 2010-09-05 00:00:00
2010-07-22 00:00:00 | RR1534
2010-07-22 00:00:00 | RR1535
2010-07-22 00:00:00 | RR1536 | 2010-09-05 00:00:00
2010-07-23 00:00:00 | RR1537 | 2010-09-23 00:00:00
2010-07-27 00:00:00 | RR1538 | 2010-10-10 00:00:00
2010-07-27 00:00:00 | RR1539 | 2010-09-12 00:00:00
2010-07-28 00:00:00 | RR1540
2010-07-29 00:00:00 | RR1541
2010-07-30 00:00:00 | RR1542
2010-07-28 00:00:00 | RR1543
2010-08-02 00:00:00 | RR1544 | 2010-09-20 00:00:00
2010-08-02 00:00:00 | RR1545
2010-08-04 00:00:00 | RR1546
2010-08-04 00:00:00 | RR1547
2010-08-04 00:00:00 | RR1548
2010-08-04 00:00:00 | RR1549
2010-08-05 00:00:00 | RR1550
2010-08-05 00:00:00 | RR1551
2010-08-06 00:00:00 | RR1552 | See Notes
2010-08-09 00:00:00 | RR1553
2010-08-09 00:00:00 | RR1554
2010-08-09 00:00:00 | RR1555 | See Notes
2010-08-11 00:00:00 | RR1556
2010-08-11 00:00:00 | RR1557
2010-08-12 00:00:00 | RR1558
2010-08-12 00:00:00 | RR1559
2010-08-18 00:00:00 | RR1560
 | 1561
 | 1562
2010-09-03 00:00:00 | 1563
2010-09-07 00:00:00 | RR1564
2010-09-07 00:00:00 | RR1565
2010-09-08 00:00:00 | REL1566
2010-09-08 00:00:00 | RR1567
2010-09-09 00:00:00 | REL1568
2010-09-12 00:00:00 | REL1569
2010-08-12 00:00:00 | RR1570
2010-08-17 00:00:00 | RR1571
2010-08-23 00:00:00 | RR1572
2010-08-23 00:00:00 | RR1573
2010-08-23 00:00:00 | RR1574
2010-08-24 00:00:00 | RR1575 | See Notes
2010-08-25 00:00:00 | RR1576
2010-08-25 00:00:00 | RR1577
2010-08-26 00:00:00 | RR1578
2010-08-26 00:00:00 | RR1579
2010-08-27 00:00:00 | RR1581
2010-08-27 00:00:00 | RR1582
2010-08-31 00:00:00 | RR1583
2010-09-01 00:00:00 | RR1584
2010-09-02 00:00:00 | RR1585
2010-09-02 00:00:00 | RR1586
2010-09-07 00:00:00 | RR1587 | See Notes
2010-09-07 00:00:00 | RR1588
2010-09-08 00:00:00 | RR1589
 | 1590
 | 1591
 | 1592
 | 1593
 | 1594
 | 1595
 | 1596
 | 1597
 | 1598
 | 1599
2010-09-10 00:00:00 | RR1600
2010-09-10 00:00:00 | RR1601
2010-09-13 00:00:00 | RR1602
2010-09-14 00:00:00 | RR1603
2010-09-14 00:00:00 | RR1604
2010-09-14 00:00:00 | RR1605
2010-09-15 00:00:00 | RR1606
2010-09-16 00:00:00 | RR1607
2010-09-17 00:00:00 | RR1608
2010-09-17 00:00:00 | RR1609
2010-09-20 00:00:00 | RR1610
2010-09-22 00:00:00 | RR1611
2010-09-22 00:00:00 | RR1612
2010-09-24 00:00:00 | RR1613
2010-09-24 00:00:00 | RR1614
2010-09-27 00:00:00 | RR1615
2010-09-29 00:00:00 | RR1616
2010-09-29 00:00:00 | RR1617
2010-09-30 00:00:00 | RR1618
2010-10-01 00:00:00 | RR1619
 | 1620
 | 1621
 | 1622
 | 1623
 | 1624
 | 1625
 | 1626
 | 1627
 | 1628
 | 1629
 | 1630