Spreadsheet date
Closed
Sabajeff
-
Oct 13, 2009 at 04:03 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 15, 2009 at 06:41 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 15, 2009 at 06:41 AM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Tmobile data check - Guide
- Google spreadsheet right to left - Guide
- Functions of spreadsheet - Guide
- How to reset safe folder password without losing data ✓ - Android Forum
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. learn more ✓ - Facebook Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Oct 15, 2009 at 06:41 AM
Oct 15, 2009 at 06:41 AM
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'=')
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'=')