/Using Excel AutoFill for dates
Search Knowledge Base by Keyword

Using Excel AutoFill for dates

When copying dates into our excel sample files the date format may change and you may get this error message as a result “Invalid file format. Certain months have been included multiple times.”

The best way to avoid this is to use the Excel AutoFill – Fill Months feature. Please see the steps below for more information.

1. Start with a sample file.

2. Copy and paste your performance values into the “default” column.

3. Delete all cells in the “Date” column except the first one and adjust it´s value accordingly (inception of your performance).

4. Click the first cell in the “Date” column to make it active. Then click the fill handle (a small square at the bottom right of the highlighted rectangle) and drag down to copy values from the first cell.

5. Click the plus sign at the bottom right of the highlighted selection and click Fill Months. Please note the plus sign may sometiome appear at the top as well.

6. Check the result. There should be a series of consecutive months in the Date column.

7. Save the file and import it.

Previous Use FTP to update my factsheets

Need help? Feel Free to Ask

To make this site work properly, we sometimes place small data files called cookies on your device. Most big websites do this too. Show details Ok

About cookies

What are cookies?
Cookies are small text files that are placed on your computer by websites that you visit. Websites use cookies to help users navigate efficiently and perform certain functions. Cookies that are required for the website to operate properly are allowed to be set without your permission. All other cookies need to be approved before they can be set in the browser.

How to control cookies?
You can control and delete the cookies that are stored on your computer. Please see aboutcookies.org for more information.


_gat_gtag_UA_*_1 This cookie is used by Google Analytics to store and track conversions.
Retention period: 1 hour.
Domain: www.fundpeak.com

Statistics (anonymous)

_ga This cookie is used by Google Analytics to count and track pageviews.
Retention period: 2 years.
Domain: www.fundpeak.com

_gid This cookie is used by Google Analytics to count and track pageviews.
Retention period: 1 day.
Domain: www.fundpeak.com


privacy_embeds This cookie is used by Fundpeak to store user privacy preferences.
Retention period: at least one session.
Domain: www.fundpeak.com

Third party

_GRECAPTCHA This cookie is used by Google. reCAPTCHA sets a necessary cookie when executed for the purpose of providing its risk analysis.
Retention period: 6 months.
Domain: www.google.com