## 'MONTH 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 […]
Highlight a date occuring [Conditional formatting]
Excel has a built-in feature that allows you to highlight dates if a given condition is met. Section 1 below […]
How to use the MONTH function
The MONTH function extracts the month as a number from an Excel date. 1 - January 2 - February 3 […]
Lookup and match last value – reverse lookup
This article shows a formula that performs a reverse lookup and returns the corresponding value based on the last matching […]
Time sheet for work
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 […]
How to calculate and plot pivots on an Excel chart
If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]
Pivot Table calendar
This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
Highlight events in a yearly calendar
This article demonstrates how to highlight given date ranges in a yearly calendar, this calendar allows you to change the […]
Plot date ranges in a calendar part 2
I will in this article demonstrate a calendar that automatically highlights dates based on date ranges, the calendar populates names […]
Change chart axis range programmatically
This article demonstrates a macro that changes y-axis range programmatically, this can be useful if you are working with stock […]
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 […]
Bill reminder in excel
Brad asks: I'm trying to use your formulas to create my own bill reminder sheet. I envision a workbook where […]
Create a drop down calendar
TheÂ drop down calendar in the image above uses a "calculation" sheet and a named range. You can copy the drop-down […]
Monthly calendar template #2
I have created another monthly calendar template for you to get. Select a month and year in cells A1 and […]
Count cells based on a condition and month
Janib Soomro asks: In A column, there are dates in mmddyyy format and in B column, there are two variables […]
Extract dates from a cell block schedule
Sam asks: One more question for the Calendar that you have set up above can we have a excel formula […]
Schedule recurring expenses in a calendar in excel (Personal Finance)
Below is an excel table containingÂ recurring expenses and corresponding amounts, dates and recurring intervals. An excel table allows you to […]
List all unique distinct rows in a given month
This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]
Highlight duplicates with same date, week or month
The image above demonstrates a conditional formatting formula that highlights duplicateÂ items based on date. The first instance is not highlighted, […]
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 […]
Remove duplicates within same month or year
The array formula in cell B15 extracts dates from B4:B12 if it is not a duplicate item in the same […]
Automate net asset value (NAV) calculation on your stock portfolio
Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]
Highlight odd/even months
Color odd months Conditional formatting formula: =MOD(MONTH(\$B6),2) Explaining CF formula in cell B6 Step 1 - Calculate numberÂ of month The […]
Create a quartely date range
I will demonstrate three different methods to build quarterly date ranges in this article. The two first methods have a […]
Create a monthly date range
I will demonstrateÂ three different techniques to build monthly date ranges in this article. Two of theseÂ techniques are easy because they […]
How to highlight MAX and MIN value based on month
The image above shows rows highlighted based on value in column C being the largest or smallest in that particular […]
Count unique distinct months
The formula in cell D18 counts unique distinct months in cell range B3:B16. Formula in D18: =SUMPRODUCT((FREQUENCY(DATE(YEAR(\$B\$3:\$B\$16), MONTH(\$B\$3:\$B\$16), 1), DATE(YEAR(\$B\$3:\$B\$16), […]