|Enter total word count in the green column and the spreadsheet does all the work for you.|
I've created three separate workbooks to allow you to set a daily, monthly, or annual goal based on what meets your individual needs. Click below to download.
Please note, the spreadsheets are locked. You will only be able to modify the green cells. These are the cells that drive all the formulas. To protect my work, I will not be giving out the password. If you have issues downloading or getting it to work, please let me know either in the comments or by email, and I'll send you the file(s) directly.
I think I've worked out all the bugs*, but it's possible I missed something. If you find that something doesn't work like it should or if you have any questions, please let me know. Happy writing! :)
*Spreadsheets were created with Microsoft Excel 2013. They may lose some functionality with earlier versions of Excel.