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 […]

How to use the DAY function

The DAY function extracts the day as a number from an Excel date. Table of Contents DAY Function Syntax DAY […]

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 […]

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 […]

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 […]

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 […]