'WEEKDAY function' category
How to track sector performance in the stock market – Excel template
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
How to use the WEEKDAY function
What is the WEEKDAY function? The WEEKDAY function converts a date to a number from 1 to 7 corresponding to […]
What is the WEEKDAY function? The WEEKDAY function converts a date to a number from 1 to 7 corresponding to […]
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
Calendar – monthly view
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]
Calculate date given weekday and week number
This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]
This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]
Pivot Table calendar
This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
Excel calendar [VBA]
Table of Contents Excel monthly calendar - VBA Â Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
Table of Contents Excel monthly calendar - VBA Â Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]
Create date ranges that stay within month
This article demonstrates a formula that creates date ranges based on a given number of days and the end date […]
This article demonstrates a formula that creates date ranges based on a given number of days and the end date […]
Monthly calendar template
The image above shows a calendar that is dynamic meaning you choose year and month and the calendar instantly updates […]
The image above shows a calendar that is dynamic meaning you choose year and month and the calendar instantly updates […]
Populate cells dynamically in a weekly schedule
In this post I am going to add one more function to the weekly schedule I built in a previous […]
In this post I am going to add one more function to the weekly schedule I built in a previous […]
Calculate machine utilization
Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]
Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]
How to calculate a date based on specific weekday in a month
Question: How to calculate the date of the third Monday of a given month? Answer: Column B contains dates of […]
Question: How to calculate the date of the third Monday of a given month? Answer: Column B contains dates of […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values