Payroll Calendar From SharePoint List

Occasional Contributor

Not sure why this is happening but here is the output of the SharePoint list file that I just uploaded from Excel. Take a look at the Excel Source file.  Pay Period starts at 01/01/2023 but for some reason SharePoint changes the dates to 12/31/2022 9:00PM.  Its like its adjusting the date by one date.  Why is this happening?


SharePoint Site



Source File



2 Replies

@FlowTime1990 Could it be your SharePoint Site Time Zone is different from that of your Excel spreadsheet? Check Regional Settings via Settings -> Site Settings -> View all site settings -> Regional settings.





best response confirmed by FlowTime1990 (Occasional Contributor)

@thebernardlim_   I think you are 100% correct.  That makes sense :)