Microsoft Excel Functions & Formulas

Use the TEXT function to calculate with

the TODAY function

A project starts today and ends 10 days later. These dates are

shown in cells B1 and B2. The end date has to be calculated based

on the start date, and the dates have to be combined with additional

text to form the message shown in cell A4.

4

To calculate with the TODAY function:

1. In cell B1 type the formula =TODAY().

2. In cell B2 type the formula =TODAY()+10 to add ten days

to the current date.

3. Select cell A4 and type the following formula: ="The

project starts on " & TEXT(B1,"MM/DD/YYYY") & "

and ends on " & TEXT(B2,"MM/DD/YYYY").

4. Press <Enter>.

Note: The TEXT function (TEXT(value, format_text)) ...