Title using Functions

[PistolPete7]

I need to make a title using excel with dates

[shirleyxls]

If your date is already in a cell, you could do it like this:

Please Login or Register  to view this content.

Or if you want it to use today's date instead of referencing a cell:

Please Login or Register  to view this content.

[JohnTopley]

Try

="Staffing information for " & TEXT(A1,"dddd: dd/mm/yyyy")


A1 is your date

[PistolPete7]

If your date is already in a cell, you could do it like this:

Please Login or Register  to view this content.

Or if you want it to use today's date instead of referencing a cell:

Please Login or Register  to view this content.

Thanks worked a charm

[shirleyxls]

My pleasure!
Don't forget to mark your problem as solved.


Excel is a constant learning process and it's great to help each other. If I've helped you today, a click on the star on the left is appreciated.