OLE Automation Date

TIL about the [Excel serial date number](https://support.microsoft.com/en-us/office/date-systems-in-excel-e7fe7167-48a9-4b96-bb53-5612a800b487) format. #

They’re also known as an OLE Automation date - which, I assume, is how mechanical bulls track their calendars. #

The date is present in the format 45911.32361 where #

1. The integer part 45911 represents the number of days since the epoch date. #
2. The decimal part .32361 represents the fraction of a day, ie the time of day #

I had a zap populate a google sheet with “current time”. The formatting helper in Zapier shows the current time in a specific format but either #

1. google sheets automatically converted it to the excel format (for some reason?!) when it saw the date from Zapier OR #
2. The web hook from squarespace is hooking into a db/csv/something that is optimised for excel, as opposed to coming from the form directly (which makes sense). #