Excel 2007 : How to add todays date as part of hyperlink

Howdy,

Okay, so in A1 I have =Today(). The cell's format is mmddyy so today date would appear as 021411

How would I add that to Http;//www.someplace.com/(date goes here).shtml

To be clear each day the hyperlink would reflect a new date.

Today would be - Http;//www.someplace.com/021411shtml
Tomorrow would be -Http;//www.someplace.com/021511shtml
and so on.

I can do it in javascript

Please Login or Register  to view this content.

Thanks in advance,

George

Use HYPERLINK & TEXT

Please Login or Register  to view this content.

add text to display if desired (see XL Help)