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

General
1

Hi!

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?

2

Have you tried lubridate?

3

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