DAY function
Excel » Functions » Date and Time » DAY function »
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 […]
The DAY function extracts the day as a number from an Excel date. Table of Contents DAY Function Syntax DAY […]
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 […]
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 […]
Brad asks: I'm trying to use your formulas to create my own bill reminder sheet. I envision a workbook where […]
The drop down calendar in the image above uses a "calculation" sheet and a named range. You can copy the drop-down […]
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 […]
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 […]