Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 06:33 AM
Shawn Lyons
 
Posts: n/a
Default How Do I Get a date reference when linking excel worksheets?

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

  #3   Report Post  
Old May 16th 05, 04:27 PM
Shawn Lyons
 
Posts: n/a
Default

what I am trying to do is reference the sheet with the corresponding day #
using the "reference formula" for the date.. I have a workbook with sheets
dated 1-31 that I use for daily sales tracking but I need to reference the
individual days on a daily basis so that only the current days sheet will be
shown in the overall seperate spreadsheet.

"Bob Phillips" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Excel to Outlook?? Pegasusnb7 Excel Discussion (Misc queries) 1 May 5th 05 10:32 PM
excel formula counting date to date in 4 columns stuie d Excel Worksheet Functions 1 May 4th 05 12:46 PM
Can Excel notify me when a date is due? Claire Chandler Excel Discussion (Misc queries) 3 February 8th 05 03:11 PM
Excel 2002 date formulas problem Andrew Warren Excel Worksheet Functions 4 January 6th 05 11:35 AM
USING THE DATE FORMAT IN EXCEL teach Excel Discussion (Misc queries) 3 December 14th 04 11:55 PM


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017