Syntax or pattern
Return the week number of a date.
=WEEKNUM(date, [type])5 practical examples
Calculate days until due
Show how many days remain before a due date.
=DAYS(D2, TODAY())Adjust the ranges, criteria and sheet names to match your workbook.
Find the end of the month
Return the last day of the month for reporting.
=EOMONTH(A2, 0)Adjust the ranges, criteria and sheet names to match your workbook.
Add business days
Calculate a due date that skips weekends and holidays.
=WORKDAY(A2, 5, Holidays!A:A)Adjust the ranges, criteria and sheet names to match your workbook.
Count working days
Count business days between start and end dates.
=NETWORKDAYS(A2, B2, Holidays!A:A)Adjust the ranges, criteria and sheet names to match your workbook.
Create a month label
Convert dates into a stable month label for summaries.
=TEXT(A2, "yyyy-mm")Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Treating dates as text instead of real date values.
- Forgetting weekends or holidays in business-day calculations.
- Using inconsistent date formats in imported data.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for weeknum examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.