Spreadsheet: 297781d1392580024-how-do-i-convert-due-date-into-this-week-or-next-week-using-pivot-or-formula-sample-excel-ndm
Sheet: Estimate Requests

Date Due | Project id | Waiting For | Date Reviewed | Estimate Amount | Target Completion Date | Date Completed or Closed | Completed On Time? | Late Due to Group: | Chewning or Rezvani / Betten | PIF Date | PMT available for HOM? | PROGRAM | Date entered in Scorecard | Estimator
2014-02-14 00:00:00 | 257225 |  | 2014-02-12 00:00:00 |  |  |  |  |  |  |  |  | MIS |  | [NAME]
2014-02-17 00:00:00 | 271126 | SE |  |  |  |  |  |  |  | 2/10/14 & 2/7/2014 |  |  |  | Carmen
2014-02-17 00:00:00 | HOM 377 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-18 00:00:00 | 270866 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-18 00:00:00 | 270866 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-18 00:00:00 | 271147 | SE |  |  |  |  |  |  |  | 2014-02-07 00:00:00 |  | IPv6 |  | [NAME]
2014-02-18 00:00:00 | 271147 | SE |  |  |  |  |  |  |  | 2014-02-07 00:00:00 |  | Ipv6 |  | [NAME]
2014-02-18 00:00:00 | HOM 378 |  |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-20 00:00:00 | 251758 |  |  |  |  |  |  |  |  |  |  | BVoIP |  | Carmen
2014-02-20 00:00:00 | 251758 |  |  |  |  |  |  |  |  |  |  | BVoIP |  | Carmen
2014-02-21 00:00:00 | 261825 | SE |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-21 00:00:00 | 257225 |  |  |  |  |  |  |  |  |  |  | MIS |  | [NAME]
2014-02-21 00:00:00 | 264615 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-21 00:00:00 | 264615 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-21 00:00:00 | 270991 |  |  |  |  |  |  |  |  | 2014-02-14 00:00:00 |  |  |  | Kelly
2014-02-24 00:00:00 | 243507 |  |  |  |  |  |  |  |  |  |  | BVoIP |  | [NAME]
2014-02-24 00:00:00 | 243507 |  |  |  |  |  |  |  |  |  |  | BVoIP |  | [NAME]
2014-02-24 00:00:00 | 254799 |  |  |  |  |  |  |  |  |  |  | AVPN |  | [NAME]
2014-02-24 00:00:00 | 254799 |  |  |  |  |  |  |  |  |  |  | AVPN |  | [NAME]
2014-02-24 00:00:00 | 253139 |  |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-24 00:00:00 | 253139 |  |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-24 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-24 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-24 00:00:00 | 261565 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-24 00:00:00 | 261565 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-24 00:00:00 | 262997 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-24 00:00:00 | 262997 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-24 00:00:00 | 270992 |  |  |  |  |  |  |  |  | 2014-02-14 00:00:00 |  | BVoIP |  | [NAME]
2014-02-24 00:00:00 | 271246 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-25 00:00:00 | 262072 |  |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-25 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-25 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-25 00:00:00 | 269074 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-25 00:00:00 | HOM 379 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-25 00:00:00 | HOM 380 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-25 00:00:00 | HOM 381 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-25 00:00:00 | HOM 382 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-26 00:00:00 | 236941 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-26 00:00:00 | 236941 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-26 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-26 00:00:00 | 254216 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-26 00:00:00 | 257225 |  |  |  |  |  |  |  |  |  |  | MIS |  | [NAME]
2014-02-26 00:00:00 | 260836 |  |  |  |  |  |  |  |  |  |  |  |  | Carmen
2014-02-26 00:00:00 | 260836 |  |  |  |  |  |  |  |  |  |  |  |  | Carmen
2014-02-26 00:00:00 | 263739 |  |  |  |  |  |  |  |  |  |  | AVPN |  | Carmen
2014-02-26 00:00:00 | 263739 |  |  |  |  |  |  |  |  |  |  | AVPN |  | Carmen
2014-02-27 00:00:00 | 255108 |  |  |  |  |  |  |  |  |  |  | AGILE |  | [NAME]
2014-02-27 00:00:00 | 255108 |  |  |  |  |  |  |  |  |  |  | AGILE |  | [NAME]
2014-02-27 00:00:00 | 257579 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-27 00:00:00 | 258659 |  |  |  |  |  |  |  |  |  |  |  |  | Kelly
2014-02-27 00:00:00 | 269232 |  |  |  |  |  |  |  |  | 2014-02-17 00:00:00 |  |  |  | Franca
2014-02-27 00:00:00 | HOM 383 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-27 00:00:00 | HOM 383 |  |  |  |  |  |  |  |  |  |  |  |  | Franca
2014-02-28 00:00:00 | 223119 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-28 00:00:00 | 230807 | APM/SE |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-28 00:00:00 | 264615 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-28 00:00:00 | 264615 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]