'YEAR function' category
The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]
Excel has a built-in feature that allows you to highlight dates if a given condition is met. Section 1 below […]
The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]
This article shows a formula that performs a reverse lookup and returns the corresponding value based on the last matching […]
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]
If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]
This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]
This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
What's on this page How to use this Excel Calendar How to add events How I built this calendar Worksheet […]
Did you know that you can use a pivot table to summarize portfolio holdings at any point in time? If you trade […]
This article demonstrates a macro that changes y-axis range programmatically, this can be useful if you are working with stock […]
The image above shows an Excel chart of the S&P 500 with buy and sell signals based on a 50 […]
This article demonstrates a formula that creates date ranges based on a given number of days and the end date […]
Janib Soomro asks: In A column, there are dates in mmddyyy format and in B column, there are two variables […]
This article demonstrates a formula that extracts unique distinct records/rows for a given month specified in cell C2, see the […]
The image above demonstrates a conditional formatting formula that highlights duplicate items based on date. The first instance is not highlighted, […]
The image above demonstrates a formula in cell E3 that extracts duplicate items if they are on the same date. […]
The array formula in cell E3 counts unique distinct items for all dates within the same week. Example, week 2 […]
The array formula in cell B15 extracts dates from B4:B12 if it is not a duplicate item in the same […]
Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]
Excel has a great built-in tool for creating number series named Autofill. The tool is great, however, in some situations, […]
Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Explaining CF formula in cell B6 Step 1 - Calculate number of month The […]
I will demonstrate three different methods to build quarterly date ranges in this article. The two first methods have a […]
I will demonstrate three different techniques to build monthly date ranges in this article. Two of these techniques are easy because they […]
The image above shows rows highlighted based on value in column C being the largest or smallest in that particular […]
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), […]
The formula in cell C3 calculates the last date for the given month and year in cell B3. =DATE(YEAR(B3), MONTH(B3)+1, […]