quick question plz

[Legacy 237453]

Hi Peeps

I have this text in cell D1..."Morning checks for 19/04/13"
my question is how do i get the date to change automatically? ive tryed the date function but for some reason it keeps deleting my text.

Thanks

 

[JoeMo]

Hi Peeps

I have this text in cell D1..."Morning checks for 19/04/13"
my question is how do i get the date to change automatically? ive tryed the date function but for some reason it keeps deleting my text.

Thanks

In D1:
="Morning checks for "&TEXT(TODAY(),"dd/mm/yyyy")

 

[Legacy 237453]

Thanks man! Perfect

 

[Piktro]

Somebody beat me to it

 

[Robert Mika]

Custom Format:
"Morning Checks for" dd/mm/yyyy
Then enter =TODAY() in cell