jbbraswell Author

Level 1

5 points

How do you convert a date to serial number in numbers?

How do you convert a date to serial number in numbers?

Posted on Mar 11, 2022 7:33 AM

Reply

Similar questions

Convert serial numbers in Numbers to date format I have an Excel file that was converted to Numbers and the dates are now Serial Numbers. How do I convert these numbers to a date format?
1471 2
randbetween date how to RANDBETWEEN between two dates? originally I wanted to use DATEVALUE to generate the serial number of the date but instead of generating number it still returns date help me, pls
279 1
How can I convert in Numbers date value (i.e 359d) in numerical value? Community, can you please help me with the conversion of date value (i.e 359d) in numerical value (i.e 359) in Numbers?
652 2

1 reply

Level 8

37,262 points

Mar 11, 2022 8:22 AM in response to jbbraswell

If you mean serial number date as used in Excel then one way is to do something like this:

=DUR2DAYS(A2−DATE(1899,12,31))+1

Replace the , in the formula with ; if your region uses , as decimal separator, e.g.,

=DUR2DAYS(A2−DATE(1899;12;31))+1

SG

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do you convert a date to serial number in numbers?

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up