How to convert a date to serial number ??

[jonnyA]

Looking for help on how to convert a date to a serial number?

[vsgreaves]

Taking the VALUE() of the date gives you the serial number. 

[jonnyA]

I cant do what you did on my end, but thank you for trying!

[v-easonf-msft]

Hi, @jonnyA 

What is your data connection mode? Have you considered using the format function to create a new calculated column?

Best Regards,
Community Support Team _ Eason

[ryan_mayu]

@jonnyA 

what about change the data type to whole number?

[jonnyA]

@ryan_mayu How do you do that?

[ryan_mayu · Accepted solution]

@jonnyA 

pls try this

[jonnyA]

@ryan_mayu 

I do not see anything from your previous message.  Did you attach a screen shot?

[ryan_mayu]

@jonnyA 

I inserted a pic. now i attached a screenshot.  pls take a look