Create Calculated Field SharePoint to Count Days
Formula Used
The calculator uses a date difference formula. The basic method is:
Days = End Date - Start Date.
When inclusive counting is selected, the formula becomes:
Days = End Date - Start Date + 1.
For filtered days, the tool checks each date in the range.
It removes weekends when selected.
It also removes listed holiday dates.
Estimated hours use:
Filtered Days × Work Hours Per Day.
SharePoint Calculated Field Examples
| Purpose | Calculated Field Formula |
|---|---|
| Direct day difference | =([End Date]-[Start Date]) |
| DATEDIF day count | =DATEDIF([Start Date],[End Date],"d") |
| Inclusive day count | =DATEDIF([Start Date],[End Date],"d")+1 |
| Signed day count | =IF([End Date]>=[Start Date],DATEDIF([Start Date],[End Date],"d"),-DATEDIF([End Date],[Start Date],"d")) |
How to Use This Calculator
Enter the start date first. Then enter the end date. Choose today when the range should end on the current date.
Select inclusive counting when both boundary dates should be counted. Use weekend removal for business style results. Add holiday dates with commas.
Choose signed mode when reversed dates should show a negative value. Choose error mode when reversed dates should be blocked. Press the calculate button. The result appears above the form.
Use the CSV button for spreadsheet records. Use the PDF button for a printable summary. Keep the SharePoint formulas for list column setup.
Example Data Table
| Task | Start Date | End Date | Option | Expected Result |
|---|---|---|---|---|
| Ticket Open Time | 2026-06-01 | 2026-06-10 | Standard | 9 days |
| Inclusive Project Range | 2026-06-01 | 2026-06-10 | Include end date | 10 days |
| Business Review | 2026-06-01 | 2026-06-10 | Exclude weekends | Business day count |
| Delayed Approval | 2026-06-10 | 2026-06-01 | Signed mode | -9 days |
Day Count Planning for SharePoint Lists
Why Day Count Fields Matter
SharePoint lists often store tasks, requests, tickets, approvals, and service records. Each item may need a clear age value. A calculated day field helps teams see delays fast. It also helps managers sort old work. Clean day counts support reports. They make list views easier to scan.
Calendar Days and Business Days
Calendar days count every date in the range. This method is useful for contracts and deadlines. Business day logic is different. It removes Saturdays and Sundays. Holiday removal adds another filter. That gives a more practical work estimate. This calculator supports both styles. You can compare the results before creating a column.
Inclusive and Standard Counting
Standard counting measures the gap between two dates. For example, Monday to Tuesday is one day. Inclusive counting counts both dates. Monday to Tuesday becomes two days. Project teams often prefer inclusive ranges. Ticket age fields usually use standard ranges. The right choice depends on your process.
Handling Reversed Dates
Some lists contain bad or early data. End dates may appear before start dates. Absolute mode always returns a positive count. Signed mode shows a negative result. Error mode blocks the calculation. Signed results are useful for audits. Error handling is useful for strict forms.
Better Reporting
Calculated fields improve filters and grouped views. Teams can create aging buckets. Examples include zero to seven days. Another bucket can show overdue items. Exported CSV files help further analysis. PDF files support quick sharing. Use the formulas as a starting point. Test them with your list names.
FAQs
What does this calculator do?
It counts days between two dates. It can include the end date, remove weekends, remove holidays, and estimate work hours.
Which SharePoint formula counts days?
Use =DATEDIF([Start Date],[End Date],"d") for a basic day count. Use direct subtraction when simple numeric difference is enough.
How do I count both start and end dates?
Add one day to the normal difference. A common formula is =DATEDIF([Start Date],[End Date],"d")+1.
Can SharePoint calculated columns exclude weekends?
Weekend exclusion is possible, but formulas can become complex. For heavy business calendars, Power Automate or list formatting may be easier.
Can holiday dates be excluded?
This calculator can remove listed holidays. Standard calculated columns do not easily reference a separate holiday list without extra workflow logic.
Why is my result one day short?
You are probably using standard date difference logic. Standard logic counts the gap between dates. Inclusive logic counts both boundary dates.
What does signed mode mean?
Signed mode returns a negative value when the end date is earlier than the start date. It helps detect reversed date entries.
Can I export the result?
Yes. After calculation, use the CSV button for spreadsheet use. Use the PDF button for a printable result summary.