acirE
New member
- Joined
- Nov 12, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- O365 ProPlus Version 1908
I received a spreadsheet to be used for recording time for payroll. One sheet stores the description, date, and hours spent in 3 respective columns, this is a an ongoing record which can have any dates in it. The second sheet has 2 date ranges (week 1 and week 2 of the current pay period) and uses a Macro to scan the first sheet and copy all unique descriptions for that date range over to the second sheet. It then uses various SUMIF formula's and such to create the rest of the time card. It successfully completes this for days of the month 1-9, but when it hits day 10 it no longer copies the descriptions over. If this problem occurred at 12 I would assume its a date formatting issue, but what would cause it to work for day 9 of a month but not 10.