How to create a series of date in this format in excel

**thunderspeed** · 10-28-2020, 10:27 PM

Hello everyone,

I need to create a series in the format dd/mm/yyyy in excel.

Thanks for your help

**MarvinP** · 10-28-2020, 11:05 PM

Hi TS,

All you need to do is format your dates in your format. Read https://support.microsoft.com/en-us/...5-db95123d273e

Dates are really "number of days since 1/1/1900". Put in some numbers and format them as your preferred date format.

**thunderspeed** · 10-31-2020, 10:46 AM

Thanks, that worked !

**alansidman** · 10-31-2020, 11:02 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

How to create a series of date in this format in excel

LinkBack

Thread Tools

Rate This Thread

Display

How to create a series of date in this format in excel

Re: How to create a series of date in this format in excel

Re: How to create a series of date in this format in excel

Re: How to create a series of date in this format in excel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert NUMBER Series entered as TEXT To DATE FORMAT mm/dd/yyyy

Converting Twitter date format to standard Excel date format to use with WEEKDAY function

convert series of numbers to date format

Using Conditional Format to autoshade a calendar based on a series or date ranges

[SOLVED] How do I create a dynamic series of months in excel?

[SOLVED] Create a formula to fill in a date series without using

in excel create series in the presence of [ ] characters

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions