How to convert R Date into Excel numeric serial date?

Viewed 3071

Excel stores dates internally as floating-point serial date. We know how to convert it into R - using as.Date(var2, origin="1899-12-30", tz='UTC').

The question is: how to convert it back into Excel? I tried all the obvious things, but I still get a mismatch.

1 Answers
Related