Automatic the date

**TaGY2K** · 02-25-2009, 06:56 PM

Hi, how can you automatic the date to today's date when you open the excel file?

ie.

Price Report For 02/25/09

**VBA Noob** · 02-25-2009, 07:01 PM

Maybe

="Price Report For "& TEXT(TODAY(),"mm/dd/yy")

Changes to today's date when workbook opened

VBA Noob

**TaGY2K** · 02-26-2009, 04:44 PM

Hi, I try this for yesterday's date and it doesn't work..

="Price Report For "& TEXT(YESTERDAY(),"mm/dd/yy")

**excellentexcel** · 02-26-2009, 04:49 PM

try

="Price Report For "& TEXT(TODAY()-1,"mm/dd/yy")

**VBA Noob** · 02-26-2009, 04:51 PM

No such excel function as

YESTERDAY()

Try excellentexcel adjustment

VBA Noob

**TaGY2K** · 02-26-2009, 04:56 PM

works .. thanks..

Re: Automatic the date