Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

Avoid entering the date in more than one place by linking headings and cells to one particular date

1. Enter the date in cell A1 of the current worksheet

2. Enter the following formula into the heading cell (include all punctuation)

3. ="My heading " & text(A1, "dd/mm/yyyy")

4. Change the text "My heading " to be your required heading

5. Change the "dd/mm/yyyy" to format the date as required

The following list shows some of the date formats you can apply in your heading (e.g. format 30/07/2003)

• "d/mm/yy" = 30/7/03

• "dd/mm/yyyy" = 30/07/2003

• "dd mmm yyyy" = 30 Jul 2003

• "mmmm yyyy" = July 2003

Excel Tips Index