Qauy accouting spreadsheet not accepting 2010

[trsisko]

any ideas even though its set for NOv 09 to FEB 2010 whenever I input 2010 dates for invoices and reciepts it just says invalid date

[pmeswani]

any ideas even though its set for NOv 09 to FEB 2010 whenever I input 2010 dates for invoices and reciepts it just says invalid date

Silly question, but have you asked Quay Accounting the question, especially as it is their piece of work.

Just a thought.

[Mat7777]

open up a new spreadsheet and type in the dates you need then copy and paste into the Quay one - or email them and ask them for the latest version - like i did

[xoggoth]

Data Validation set probably. It's a sort of formatty thing that only allows certain values to be entered, like from a specified list. Last suggestion of copy and paste should work too.