ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date Format?? (https://www.excelbanter.com/excel-programming/348353-date-format.html)

mvyvoda

Date Format??
 
i need to use DateSerial for this format 2005-11. how the heck do i do that?

thanks,
mark

john

Date Format??
 
you can use the code following:

Format(now, "yyyy-dd")

Best Regards
John Black

"mvyvoda" wrote in message
...
i need to use DateSerial for this format 2005-11. how the heck do i do

that?

thanks,
mark





All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com