How do you convert a date to serial number in numbers?
How do you convert a date to serial number in numbers?
Question marked as
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