VBA & Macro Problems

Create Daily Excel Sheets for a Month with Dates and Formulas

John WilsonJohn Wilson Nov 18, 2026 870 views

Question details

Create a month's daily worksheets with updated dates and preserved formulas, or use a more scalable way to track labor.

Create Daily Excel Sheets for a Month with Dates and Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the records table

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.

2
Enter daily records

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.

3
Summarize the month

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.

Track labor in one Excel table and summarize by date
Simplify labor tracking

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. 1. Open a workbook: Open WPS Spreadsheets and create a blank workbook or open an existing Excel workbook.
  2. 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. 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. 4. Save the workbook: Choose File > Save As and select the XLSX format if you need to share the workbook with Excel users.
Keep daily labor records together in a searchable worksheetCalculate hours for a selected date with SUMIFOpen and save Microsoft Excel XLSX workbooksUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.