How do I read tab numbers into formula?
I want to use the tab number to automatically create a date. For example, I
want to use tab number 1 to create a date in a cell on the same page. 1 for the 1st, 10 for the 10th, etc. How do I read the tab number into my formula? |
take a look he
http://www.mcgimpsey.com/excel/formu..._function.html In article , "Gregg" wrote: I want to use the tab number to automatically create a date. For example, I want to use tab number 1 to create a date in a cell on the same page. 1 for the 1st, 10 for the 10th, etc. How do I read the tab number into my formula? |
Thanks so much... works great for what I needed!
"JE McGimpsey" wrote: take a look he http://www.mcgimpsey.com/excel/formu..._function.html In article , "Gregg" wrote: I want to use the tab number to automatically create a date. For example, I want to use tab number 1 to create a date in a cell on the same page. 1 for the 1st, 10 for the 10th, etc. How do I read the tab number into my formula? |
All times are GMT +1. The time now is 02:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com