Convert date

[Ruan17]

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

[Niklas_Hatje]

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

[Ruan17]

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

[jonflow]

The relation is number of days from Jan 1 1900

[martinhache]

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:

[Ruan17]

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