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
The relation is number of days from Jan 1 1900
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
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.