Create Daily Excel Sheets for a Month with Dates and Formulas
Question details
Create a month's daily worksheets with updated dates and preserved formulas, or use a more scalable way to track labor.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A labor-tracking workbook needs dated daily records and formulas for each new month.
- Observed behavior
- The goal is to generate daily tabs from a template or maintain records in one table that can be summarized by date.
Decide whether you need separate daily tabs or can keep all labor records in one table. For the VBA method, prepare a worksheet named Daily Template with its date in cell B1 and formulas that refer to that cell where appropriate.
Track labor in one Excel table and summarize by date
Use a single table when separate daily worksheets are not required; it makes monthly reporting easier to maintain.
On a worksheet, enter headers such as Date, Employee, Job, Hours, and Labor Cost. Select the range and choose Insert > Table, then confirm that the table has headers.
Add one row for each employee and job entry, including the work date. Enter formulas in calculated columns as needed; Excel tables can extend those formulas to new rows.
Select a cell in the table and choose Insert > PivotTable. Put Date in Rows and Hours or Labor Cost in Values, then use the date filter to show the month you need.

Generate dated daily sheets from an Excel template with VBA
Use this method when the workbook must have one worksheet per day.
Track monthly labor in one WPS Spreadsheets workbook
Use WPS Spreadsheets to keep dated labor entries in one worksheet and calculate daily totals without creating a separate tab for every day.
- 1. Open a workbook: Open WPS Spreadsheets and create a blank workbook or open an existing Excel workbook.
- 2. Set up labor columns: Enter Date, Employee, Job, Hours, and Labor Cost in row 1, then add one dated labor entry per row.
- 3. Calculate a daily total: Enter a date in G2, then enter =SUMIF(A:A,G2,D:D) in H2 to total the hours in column D for that date.
- 4. Save the workbook: Choose File > Save As and select the XLSX format if you need to share the workbook with Excel users.

Frequently Asked Questions
How does the macro know how many days are in the month?
It starts on the first day of the entered month and creates sheets until the date moves into the next month, including February in leap years.
Will the macro overwrite existing daily sheets?
No. It checks for each yyyy-mm-dd sheet name and skips any name that already exists.
Why are the dates in my copied formulas not changing?
The macro updates only B1. Edit formulas on Daily Template to reference B1 if they need to use the sheet's date, then generate the sheets again using new sheet names.
Can I summarize labor without creating daily tabs?
Yes. Store each entry with a Date column, select the data, and choose Insert > PivotTable in Excel to total hours or costs by date.




