You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

5 points

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

Posted on Mar 11, 2022 7:33 AM

Top-ranking reply

Level 8

36,134 points

Posted on Mar 11, 2022 8:22 AM

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

View in context

Similar questions