Title: When export to Excel date format changes
Last modified: August 22, 2016

---

# When export to Excel date format changes

 *  [Suzannevanduivenvoorde](https://wordpress.org/support/users/suzannevanduivenvoorde/)
 * (@suzannevanduivenvoorde)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/when-export-to-excel-date-format-changes/)
 * Dear all,
 * When we use visual form builder for an event we ask the attendees to fill in 
   their birthdate, needed for certificates to hand out after event. When I export
   the form to Excel all details come out correctly. However some attendees do not
   use the proper date format as we want to have it like ’29 December 1968′. Then
   I manually change it in the right format but when I save the document it changes.
   Excel adds 1 day to the date and 4 years to the year. f.e. 6 May 1951 becomes
   7 May 1955. It really drives me crazy, can someone help me out?
 * [https://wordpress.org/plugins/visual-form-builder/](https://wordpress.org/plugins/visual-form-builder/)

The topic ‘When export to Excel date format changes’ is closed to new replies.

 * ![](https://ps.w.org/visual-form-builder/assets/icon-256x256.png?rev=1205840)
 * [Visual Form Builder](https://wordpress.org/plugins/visual-form-builder/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/visual-form-builder/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/visual-form-builder/)
 * [Active Topics](https://wordpress.org/support/plugin/visual-form-builder/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/visual-form-builder/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/visual-form-builder/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Suzannevanduivenvoorde](https://wordpress.org/support/users/suzannevanduivenvoorde/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/when-export-to-excel-date-format-changes/)
 * Status: not resolved