'WEEKNUM function' category


You are here: Excel » Functions » Date and Time » WEEKNUM function »

How to use the WEEKNUM function
The WEEKNUM function calculates a given date's week number based on a return_type parameter that determines which day the week […]
Highlight a date occuring [Conditional formatting]
Excel has a built-in feature that allows you to highlight dates if a given condition is met.The date conditions you […]
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
Filter duplicates within same date, week or month
The image above demonstrates a formula in cell E3 that extracts duplicate items if they are on the same date. […]
Count unique distinct values within same week, month or year
The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]

Excel categories

FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive