| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Can excel read numbers in the Sexagesimal system (DMS)? | Excel Worksheet Functions | |||
| Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
| Formula between to numbers is true multiply | Excel Worksheet Functions | |||
| How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
Linear Mode
