'TEXT function' category
The following conditional formatting formula highlights dates based on day of the week. =TEXT(B3,"DDDD")=$D$3 The TEXT function converts a value […]
Excel has a built-in feature that allows you to highlight dates if a given condition is met. Section 1 below […]
The formula in cell D5 calculates the number of complete hours between the time entries in cell B5 and C5. […]
The formula in cell D3 converts the radian decimal value to fractions of pi. Formula in cell D3: =TEXT(C3/PI(),"?/?")&"*"&CHAR(182) Explaining […]
The following array formula, demonstrated in cell C3, extracts all numbers from a cell value: =TEXTJOIN(, 1, TEXT(MID(B3, ROW($A$1:INDEX($A$1:$A$1000, LEN(B3))), […]
This article demonstrates an array formula that extracts all characters except numbers from a cell, cell C3 contains the formula […]
This article demonstrates how to use the TEXT function in great detail. The formula in cell D3 formats the number […]
This article demonstrates a formula that calculates a running total. A running total is a sum that adds new numbers […]
If you study a stock chart you will discover that sometimes significant trend reversals happen when a stock chart […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
This article demonstrates a formula that returns a date range that a date falls under, cell C3 above contains the […]
The image above shows an Excel chart of the S&P 500 with buy and sell signals based on a 50 […]
NETWORKDAYS function returns the number of whole workdays between two dates, however the array formula I am going to demonstrate […]
The formula in cell B7 and C7 extracts whole weeks within the given date range in cell B3 and C3. […]
Steve asks: Right now I'm using the following formula to tell me how many of a specific defined day, ie […]
Shannon asks:I need a formula that if I enter a start date in field B1 such as 6/8/11 it will […]
I have created another monthly calendar template for you to get. Select a month and year in cells A1 and […]
This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]
Question: How to create unique distinct year and months from a long date listing (column A)? You can find the […]
Excel has a great built-in tool for creating number series named Autofill. The tool is great, however, in some situations, […]
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 […]
Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]
Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 […]