View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

do you mean?

TEXT(DATE,"dd")

--
HTH

Bob Phillips

"Shawn Lyons" <Shawn wrote in message
...
I am trying to reference a sheet in a multi sheet workbook in another
worksheet to compile data daily. the formula would be as follows...
='[filename] DATE (day format) 'cell I need to know how to referenece

the
date in a day (ie 5/15/05 as 15) in order to reference the specific sheet

in
the other workbook