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?
- Spreadsheet function - Guide
- Tmobile data check - Guide
- We weren't able to confirm your identity from the video you submitted. you can submit a new video and we'll review it again. learn more. - Instagram Forum
- Google spreadsheet right to left - Guide
- Selfie video verification upload error ✓ - Instagram 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'=')
