How to convert numeric dates from R to numeric dates in Excel


I have numeric values equivalent to dates in R (dates imported from .csv file and modified to numeric using also as.Date(..., origin= "1899-12-30")) and for now I have numeric values of dates according to R standards (ex. numeric value '18365' means 2020/04/13).

I need to modify these values into numeric values equivalent to Excel numeric dates (ex. mentioned 2020/04/13 into 43934).

How can I do that?

Have you tried lubridate?

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