TEXT function


Excel » Functions » Text » TEXT function »

How to convert radians to fractions of pi

The formula in cell D3 converts the radian decimal value to fractions of pi. Formula in cell D3: =TEXT(C3/PI(),"?/?")&"*"&CHAR(182) Explaining […]

How to use the TEXT function

Excel function syntax TEXT(value, format_text) Converts a value to text in a specific number format. Arguments value - The string […]

Count a specific weekday in a date range

NETWORKDAYS function returns the number of whole workdays between two dates. The array formula in this blog post counts for […]

7 days (weekly) date ranges

Shannon asks:I need a formula that if I enter a start date in field B1 such as 6/8/11 it will […]

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