Convert date

I need to convert the date 05/30/2023 into the number 45076, so that Excel recognizes it as the date

Hi @Ruan17 transforming data in n8n is usually pretty easy. Would you mind sharing how the converion works in excel? I don’t see a relation between the date and the number you shared :sweat_smile:

I don’t see it either… but from what I understand it’s that number he uses to convert into a date

The relation is number of days from Jan 1 1900

Hey @Ruan17

As @jonflow says it is the ratio of days that have passed since 1900-01-01, so the following workflow does the corresponding calculation:



worked perfectly @martinhache ! I improved the code and managed to reduce

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.