Spreadsheet: 797909d1664210444-macro-help-needed-per-diem-macro-workbook
Sheet: per diem

Employee | Date | Did you have per diem yesterday? | Did you have any reimbursable expenses yesterday? | Employee Notes | Submitted | Device | Account
[NAME] | Mon Aug 29 | No | No |  | 2022-08-29 06:04:00 | iPhone 11 | a
[NAME] | Tue Aug 30 | No | No |  | 2022-08-30 06:01:00 | iPhone 11 | a
[NAME] | Wed Aug 31 | No | No |  | 2022-08-31 06:00:00 | iPhone 11 | a
[NAME] | Thu Sep 01 | No | No |  | 2022-09-01 05:59:00 | iPhone 11 | a
[NAME] | [NAME] 02 | No | No |  | 2022-09-02 05:58:00 | iPhone 11 | a
[NAME] | Tue Sep 06 | No | No |  | 2022-09-06 06:00:00 | iPhone 11 | a
[NAME] | Wed Sep 07 | No | No |  | 2022-09-07 06:01:00 | iPhone 11 | a
[NAME] | [NAME] | No | No |  | 2022-09-08 06:00:00 | iPhone 11 | a
[NAME] | [NAME] 09 | No | No |  | 2022-09-09 05:01:00 | iPhone 11 | a
Antony | Mon Aug 29 | No | No |  | 2022-08-29 06:27:00 | iPhone 11 | a
Antony | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 06:35:00 | iPhone 11 | a
Antony | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 07:33:00 | iPhone 11 | a
Antony | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 07:15:00 | iPhone 11 | a
Antony | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 06:57:00 | iPhone 11 | a
Antony | Tue Sep 06 | No | Yes (Flagged) |  | 2022-09-06 07:21:00 | iPhone 11 | a
Antony | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 07:21:00 | iPhone 11 | a
Antony | [NAME] | Yes (Flagged) | No |  | 2022-09-08 07:00:00 | iPhone 11 | a
Antony | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 20:57:00 | iPhone 11 | a
[NAME] | Mon Aug 29 | No | No |  | 2022-08-29 06:13:00 | iPhone XÊ€ | a
[NAME] | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 05:42:00 | iPhone XÊ€ | a
[NAME] | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 06:01:00 | iPhone XÊ€ | a
[NAME] | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 06:57:00 | iPhone XÊ€ | a
[NAME] | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 07:03:00 | iPhone XÊ€ | a
[NAME] | Tue Sep 06 | No | No |  | 2022-09-06 06:08:00 | iPhone XÊ€ | a
[NAME] | Tue Sep 06 | No | No |  | 2022-09-06 06:17:00 | iPhone XÊ€ | a
[NAME] | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 06:01:00 | iPhone XÊ€ | a
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-09-08 07:04:00 | iPhone XÊ€ | a
[NAME] | [NAME] | Yes (Flagged) | No |  | 2022-09-08 07:28:00 | iPhone XÊ€ | a
[NAME] | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 06:00:00 | iPhone XÊ€ | a
Jorge | Mon Aug 29 | No | No |  | 2022-08-29 06:11:00 | iPhone14,3 | a
Jorge | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 05:24:00 | iPhone14,3 | a
Jorge | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 06:04:00 | iPhone14,3 | a
Jorge | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 05:12:00 | iPhone14,3 | a
Jorge | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 05:19:00 | iPhone14,3 | a
Jorge | Tue Sep 06 | Yes (Flagged) | No |  | 2022-09-06 06:00:00 | iPhone14,3 | a
Jorge | Tue Sep 06 | No | No |  | 2022-09-06 06:01:00 | iPhone14,3 | a
Jorge | Wed Sep 07 | No | No |  | 2022-09-07 06:15:00 | iPhone14,3 | a
Jorge | [NAME] | No | No |  | 2022-09-08 06:50:00 | iPhone14,3 | a
Jorge | [NAME] 09 | No | No |  | 2022-09-09 06:17:00 | iPhone14,3 | a
[NAME] | Mon Aug 29 | No | No |  | 2022-08-29 06:01:00 | iPhone 11 Pro Max | a
[NAME] | Tue Aug 30 | No | No |  | 2022-08-30 06:00:00 | iPhone 11 Pro Max | a
[NAME] | Wed Aug 31 | No | No |  | 2022-08-31 06:04:00 | iPhone 11 Pro Max | a
[NAME] | Thu Sep 01 | No | No |  | 2022-09-01 06:00:00 | iPhone 11 Pro Max | a
[NAME] | [NAME] 02 | No | No |  | 2022-09-02 06:00:00 | iPhone 11 Pro Max | a
[NAME] | Tue Sep 06 | No | No |  | 2022-09-06 06:01:00 | iPhone 11 Pro Max | a
[NAME] | Wed Sep 07 | No | No |  | 2022-09-07 06:00:00 | iPhone 11 Pro Max | a
[NAME] | [NAME] | No | No |  | 2022-09-08 06:04:00 | iPhone 11 Pro Max | a
[NAME] | [NAME] 09 | No | No |  | 2022-09-09 06:00:00 | iPhone 11 Pro Max | a
Sergio | Mon Aug 29 | No | No |  | 2022-08-29 06:15:00 | [NAME] | a
Sergio | Tue Aug 30 | No | No |  | 2022-08-30 05:10:00 | [NAME] | a
Sergio | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 06:07:00 | [NAME] | a
Sergio | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 05:55:00 | [NAME] | a
Sergio | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 09:10:00 | [NAME] | a
Sergio | Tue Sep 06 | No | No |  | 2022-09-06 07:23:00 | [NAME] | a
Sergio | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 06:36:00 | [NAME] | a
Sergio | [NAME] | Yes (Flagged) | No |  | 2022-09-08 06:26:00 | [NAME] | a
Sergio | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 05:05:00 | [NAME] | a
Sergio | Sat Sep 10 | Yes (Flagged) | No |  | 2022-09-10 05:31:00 | [NAME] | a
Trent | Mon Aug 29 | No | No |  | 2022-08-29 16:16:00 | iPhone13,4 | a
Trent | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 17:54:00 | iPhone13,4 | a
Trent | Wed Aug 31 | Yes (Flagged) | No |  | 2022-09-02 07:17:00 | iPhone13,4 | a
Trent | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-02 07:17:00 | iPhone13,4 | a
Trent | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 07:14:00 | iPhone13,4 | a
Trent | Tue Sep 06 | No | No |  | 2022-09-06 15:42:00 | iPhone13,4 | a
Trent | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 15:38:00 | iPhone13,4 | a
Trent | [NAME] | Yes (Flagged) | No |  | 2022-09-08 08:26:00 | iPhone13,4 | a
Trent | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 07:40:00 | iPhone13,4 | a
Trevor | Mon Aug 29 | No | No |  | 2022-08-29 05:00:00 | SM-G998U | a
Trevor | Tue Aug 30 | No | No |  | 2022-08-30 05:00:00 | SM-G998U | a
Trevor | Wed Aug 31 | No | No |  | 2022-08-31 05:00:00 | SM-G998U | a
Trevor | Thu Sep 01 | No | No |  | 2022-09-01 04:59:00 | SM-G998U | a
Trevor | [NAME] 02 | No | No |  | 2022-09-02 05:00:00 | SM-G998U | a
Trevor | Tue Sep 06 | No | No |  | 2022-09-06 05:00:00 | SM-G998U | a
Trevor | Wed Sep 07 | No | No |  | 2022-09-07 05:01:00 | SM-G998U | a
Trevor | [NAME] | No | No |  | 2022-09-08 09:34:00 | Web Browser | a
Trevor | [NAME] 09 | No | No |  | 2022-09-09 05:01:00 | SM-G998U1 | a
[NAME] | Mon Aug 29 | No | No |  | 2022-08-29 07:01:00 | iPhone14,5 | a
[NAME] | Tue Aug 30 | No | No |  | 2022-08-30 06:08:00 | iPhone14,5 | a
[NAME] | Wed Aug 31 | No | No |  | 2022-08-31 07:15:00 | iPhone14,5 | a
[NAME] | Thu Sep 01 | No | No |  | 2022-09-01 05:36:00 | iPhone14,5 | a
[NAME] | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 06:33:00 | iPhone14,5 | a
[NAME] | Tue Sep 06 | No | No |  | 2022-09-06 06:43:00 | iPhone14,5 | a
[NAME] | Wed Sep 07 | No | No |  | 2022-09-07 11:35:00 | iPhone14,5 | a
[NAME] | [NAME] | No | No |  | 2022-09-08 10:32:00 | iPhone14,5 | a
[NAME] | [NAME] 09 | No | No |  | 2022-09-09 07:15:00 | iPhone14,5 | a
Zach | Mon Aug 29 | No | No |  | 2022-08-29 14:33:00 | iPhone 11 | a
Zach | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 17:54:00 | iPhone 11 | a
Zach | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 06:42:00 | iPhone 11 | a
Zach | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 06:41:00 | iPhone 11 | a
Zach | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 10:24:00 | iPhone 11 | a
Zach | Tue Sep 06 | No | No |  | 2022-09-06 13:55:00 | iPhone 11 | a
Zach | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 07:29:00 | iPhone 11 | a
Zach | [NAME] | Yes (Flagged) | No |  | 2022-09-08 07:23:00 | iPhone 11 | a
Zach | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 16:38:00 | iPhone 11 | a
Zachary | Mon Aug 29 | No | No |  | 2022-08-29 06:15:00 | iPhone13,4 | a
Zachary | Tue Aug 30 | Yes (Flagged) | No |  | 2022-08-30 17:29:00 | iPhone13,4 | a
Zachary | Wed Aug 31 | Yes (Flagged) | No |  | 2022-08-31 07:09:00 | iPhone13,4 | a
Zachary | Thu Sep 01 | Yes (Flagged) | No |  | 2022-09-01 19:21:00 | iPhone13,4 | a
Zachary | [NAME] 02 | Yes (Flagged) | No |  | 2022-09-02 07:14:00 | iPhone13,4 | a
Zachary | Wed Sep 07 | Yes (Flagged) | No |  | 2022-09-07 11:17:00 | iPhone13,4 | a
Zachary | [NAME] 09 | Yes (Flagged) | No |  | 2022-09-09 07:40:00 | iPhone13,4 | a