I own a tractor trailer. I keep up with weekly, monthly and yearle income and expenses. At the end of the year, I use the totals for tax purposes so I have to total everything and start over, however, the dates for the weeks in a month are not lining up. Due to this, the formulas don't seem to be accurate either. Hope this clarifies some?Hello
Your post reads a bit open ended. I mean it is a bit open to interpretation what you are asking.
The simple answer is that an Excel workbook by default has no dependencies on which year it is in. So the simple answer is just carry on as you where in the previous year.
If there is something in the workbook that may be effected by the year, then obviously that might be a different story.
I don’t think there is any point in trying to help you further unless you can explain in more detail what your question is, and to what specifically it applies. Otherwise a lot of time would be wasted trying to guess what your question actually is.
As I mentioned, a workbook itself usually has no reason to be year dependant.
Hi....... Hope this clarifies some?
=$A1+1and repeat that all the way down the column for each day. If you were dealing with the first day in each month you could use
=eomonth($A1,0)+1etc. The following year you would just need to change the date in A1 to set up the workbook for the new year.
I've had success with columns of dates by selecting the whole column, format as date, using YYYY-MM-DD format, and then entering the current date as 12jan, for example, and Excel will save it in correct format for the current year in the column. For the new year, I right-click the tab, choose copy, make copy in current book and just change the tab name to the new year. Then delete the old dates and data entries, but keep the formulas. Now this new tab can be used for the new year. You could do the same by saving the old file with the new year name, do the formatting as described above, delete the old dates and data, save, and it should be ready.What is the best way to continue workbook to new year keeping formulas and formatting, but not values?
sub resetSheet() ' Clear contents from cells C1, D2:D4 and C5 Worksheets("Sheet1").Range("C1,D2:D4,C5").ClearContents End Sub
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
|Microsoft Works to Microsoft Office||6|
|Series fill only copying and fill series greyed out||1|
|Excel sum if and closed workbooks||2|
|Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the||0|
|Inserting SSD to new kit||1|
|Excel Count If Formula Question||1|