Search : in
By :

Spreadsheet date

Last answer on Oct 15, 2009 11:41:45 am BST Sabajeff, on Oct 13, 2009 9:03:07 pm BST 
 Report this message to moderators

Hello,

Urban legend around my office says that you can put a formula into Excel that will change the date in a cell within the spreadsheet if you change the name of the spreadsheet on the tab.

For example if you name the tab, 101209, it will populate a cell in the spreadsheet with that date.

Any ideas?

Thanks,

Sabajeff

Configuration: Windows XP
Safari 532.0

Best answers for « Spreadsheet date » in :
Import webpage data into Excel spreadsheet Show
Spreadsheets - Data Entry Show Cell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
List month from any given year in excel (Solved) Show
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download Data Terminator Show
Download Simply Contacts Database Show
Download EMS Data Export for SQL Server ShowDo you need to analyze your data in your SQL Server database? Would you like to print them? EMS Data Export for SQL Server offers to export them into MS Access, MS Excel, MS Word, RTF, HTML, XML, PDF, TXT, CSV, DBF or ODF only in a few steps. This...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Worksheets ShowThe Concept of a Worksheet Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a...
Introduction to Spreadsheet Concepts ShowWhat is a Spreadsheet? A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a...
Ask your question Reply

1

 Excelguru, on Oct 15, 2009 11:41:45 am BST

Hello there

Use =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) to get the sheet name to a cell
then use =DATE(RIGHT(N20,2)+1900,MID(N20,3,2),LEFT(N20,2)) to get the date where N2 is the cell where you have applied the above formula
To get everything in one formula replace N2 with the first formula (excluding'=')

A wise man once said, 'I complained that I had no shoes until I met a man who had no feet.'
I am interested in financial Modelling and custom excel development with excel macros.

   
Reply to Excelguru
Ask your question Reply
They need your help