Thread: [Solved] Auto Populate Sheets?
View Single Post
 
Old 07-27-2018, 08:05 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

specific year range...
2018 because that's where I got the 'beginning of time' date of Jan 6, 2018 which would have been the first pay period ending in calendar 2018.
2025 is just arbitrary to prevent something like 9999 being entered and Excel taking an eternity or crashing dealing with all the pay periods 'til then.

Quote:
the state financial year, and, thus, our year, is from July to June
so July 2019 is the first month in the 2019 financial year ?

Mind if I ask why an .xls file when your profile shows Office 2010 ?
Reply With Quote