Thread
:
How Do I Get a date reference when linking excel worksheets?
View Single Post
#
2
Bob Phillips
Posts: n/a
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
Reply With Quote