I'm trying to use the data from the tab name in some <gs id="135d7cfc-d175-4723-9d7c-8909c9e466ed" ginger_software_uiphraseguid="a0d1d67e-f848-4b36-81a3-82ab5068c488" class="GINGER_SOFTWARE_mark"><gs id="872af9ed-3334-4e82-8706-c06df1a776b6" ginger_software_uiphraseguid="09ee2b9e-d455-40e8-a4d3-9348d57be669" class="GINGER_SOFTWARE_mark">formulai</gs></gs> in the workbook.
For <gs id="0535a48d-90b5-41f1-bd1f-8937bc74bf71" ginger_software_uiphraseguid="fe24fb72-3120-4806-b946-c6914aaa555b" class="GINGER_SOFTWARE_mark">example, one</gs> tab is named Dec 3-16 (This is a 2 week schedule)
The header <gs id="50a417db-7f5a-4835-8550-723d1aa5b313" ginger_software_uiphraseguid="14131413-9540-4971-bdd8-9fa42a6e58a4" class="GINGER_SOFTWARE_mark"><gs id="58ba230e-24cb-4af9-8f8d-0005a9d22933" ginger_software_uiphraseguid="0ac46178-07b4-4cda-b5bb-9aa4947d50e6" class="GINGER_SOFTWARE_mark">for</gs></gs> the week should be Dec 3-9
I've done that with this with
=CONCATENATE<gs id="68129b4d-3e9e-47c4-b16a-3c5b5fc5829a" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="1aac5375-291a-4911-8669-36ae1cb75196" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="699cf70c-8d96-483b-91d7-c7166e713d0c" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="b1c55003-7bd8-4847-b739-c0a367c2069c" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="fbc2b350-df45-44ae-8a8c-6c55f0ae70fa" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="daa6191a-d82b-4cf3-b456-03c92a485c8b" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="5cff35e6-7130-46cf-98c9-3323a204443b" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="6c524c5d-6847-4254-b5ef-32ecff6064db" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="4da3a8cd-8e28-416e-9acd-ed338fea6479" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="2f5c8e83-e98f-451a-b75a-72ef3734fcb5" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="af7bc508-7e33-4760-a303-9ab7bb8e0fe3" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="d545689e-e126-41f7-95fa-1c2bf6466492" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="a6b1b089-45a1-4ed0-9333-c6f1080e4b5f" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="1994f809-1579-4938-91ed-02f2db4246ac" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>I7)
Which comes from a cell (B1) not in the print <gs id="96120759-c473-47bd-a1fe-4d7edd5befc8" ginger_software_uiphraseguid="5fda41ec-bee8-4e63-a145-4b4390449850" class="GINGER_SOFTWARE_mark">area</gs> which gets <gs id="bcf6db2a-7740-40cd-bc76-f49b924b24c3" ginger_software_uiphraseguid="59ac0fe0-3c9d-421f-bd67-3fecdf7bcab9" class="GINGER_SOFTWARE_mark"><gs id="e39b1257-9d56-4592-8985-8aa0c89c4c16" ginger_software_uiphraseguid="15980a93-97e2-433a-bbcd-e8ddd99aab2b" class="GINGER_SOFTWARE_mark">it's</gs></gs> data from the tab title with this
=MID<gs id="8e535ada-7d7a-4109-98d4-96f6b78bcbb4" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="45e6fadc-42ee-41a7-954d-52ea2f83db3e" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>CELL<gs id="75b98a8f-4cb8-4890-ab6e-a59ee437643b" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="7d25e16f-2cff-40aa-9d41-425084ce6234" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="d7bd27a4-df62-49eb-9124-d42cbf2d260b" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="46c7b98e-c7b5-4a80-a27b-075d3cd11646" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="3f099418-d05f-4240-90dc-1ea4aad06df9" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="545702dc-5166-401e-adae-6bda4b6ba44b" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>FIND<gs id="b6338a29-63d6-414a-be0a-8186f5c69838" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="83be9725-94dd-4d00-a123-7bdd5360452c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"]"<gs id="7d28035c-854d-47b1-b6dd-caf9ed89497a" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="e7280cc9-86af-4c78-8a9b-dfd1b141deb4" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>CELL<gs id="bade118a-ad34-451d-9cc1-50021f38efcf" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="5c796926-54ba-4a4b-ac53-e828c72c638a" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="3108b776-7bd6-4135-bd78-83878ad996c2" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="e83895ea-b18a-414b-835d-e6cb66b2954c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="f7cd9d44-9242-489c-9d0a-84b16470374e" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="02d151e0-50b7-4380-a88b-ce1c73b6a72c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">)</gs></gs>+1,255)
<gs id="36862a83-e533-4b56-8a78-f4ca1adee179" ginger_software_uiphraseguid="b180d4aa-a55d-4a2f-b069-ca6d3d3a064e" class="GINGER_SOFTWARE_mark">This </gs>renders as Dec 3-16 <gs id="3e789486-22d5-40cd-a2ab-9bfb3a16a437" ginger_software_uiphraseguid="0112e147-c30d-4253-919d-058abf978154" class="GINGER_SOFTWARE_mark">which</gs> is the exact name of the <gs id="cde205a5-e822-4166-ad88-c466645852f0" ginger_software_uiphraseguid="b180d4aa-a55d-4a2f-b069-ca6d3d3a064e" class="GINGER_SOFTWARE_mark">tab</gs>
<gs id="f339d12f-62ea-43f6-b62c-48c0685ca502" ginger_software_uiphraseguid="7c389583-5353-48d3-998a-e8eaffd0638e" class="GINGER_SOFTWARE_mark"><gs id="aa729d10-6afe-4423-976c-983ee5b9dac1" ginger_software_uiphraseguid="699b0f4c-73ca-443e-acf0-7ef56cd22c20" class="GINGER_SOFTWARE_mark">however</gs></gs> the heading for the week should be Dec 3-9 not Dec 3-16 since that's for two weeks. What I need to do is extricate the first part of the tab name <gs id="e44f6f95-62ff-4ed3-9668-af8ce44b3f95" ginger_software_uiphraseguid="38e8199b-585b-453f-a231-448899db495b" class="GINGER_SOFTWARE_mark"><gs id="dac2bfaa-5ed1-42d1-a6b9-3b16f675e323" ginger_software_uiphraseguid="db305051-e860-4617-8c6d-fd5dce19e40b" class="GINGER_SOFTWARE_mark">ie</gs></gs> Dec 3- and then I need to get the value Dec 9 from somewhere. I've tried it using this
=CONCATENATE<gs id="12d9389c-01dd-4a84-b3de-840d30969450" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="2cdf1e73-e4dc-40e3-badb-f6ee055f5494" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="ac7a0209-b608-4114-b9de-4f7b066d7a5e" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="0bb7f1a7-6f81-4ffb-8e6f-41efe2675799" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="895370f7-a79f-4e3a-a683-602166ea8ced" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="6c475206-cee2-484d-b667-41c07d46d7d0" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="20648a21-0b75-4da0-8d7f-d08e607e5f6f" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="cf45fa88-da68-4018-8140-9853ab26e417" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="8e37f30c-b8c0-495d-ab25-918e5c28252c" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="abd37460-e0b6-4fa7-bd8c-26995c3764b9" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="c8aeccff-6492-4a23-b676-a4402ad7c529" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="ad55b77c-52a0-4f86-969b-8896b90496be" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="0157a9fc-b6c6-44d6-9fec-6a5c48af5c09" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="aceccb75-e4a9-4df4-9362-6e2e42321924" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>I7) I7 is from the column header of the last day of the week but the formatting isn't coming with it so it renders like this
Dec 3-43078 which is the date code for the <gs id="fb357ca5-b5a0-4ec6-bb29-847ff942696e" ginger_software_uiphraseguid="e7dcb3d3-190b-4ae3-a6e8-49ebeb9e5d61" class="GINGER_SOFTWARE_mark"><gs id="41ca3cd6-89a6-4a89-9d6e-cbc877588607" ginger_software_uiphraseguid="2a16b7e4-0483-4b9d-ba67-27f7024b1491" class="GINGER_SOFTWARE_mark">date not</gs></gs> exactly what I need
I need help to turn this date code into the corresponding date formatted Dec 9 within the cell code
=CONCATENATE<gs id="28f36dd7-4e36-4883-865f-340a579fd31c" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="24255f1e-ee50-4dce-9be6-c37f6d669199" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="4383e351-40a4-4ba0-a3e3-1e7729ea9796" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="0f83ea97-d8fb-4593-bbed-cf80aac3fc88" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="2f4ec75d-ee6a-4ba7-ac2d-e996f2a80a68" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="e1486690-a0a6-44bb-bcfb-c97ac056ba5b" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="430d1574-cdf1-4c81-b622-e14807aef667" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="0bc4c606-9fc9-43de-a5a4-66749f40d871" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="69b13eed-c161-405b-bbeb-ae82f8194c78" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="d9f529bc-9152-4752-ba2e-38ab2108fe78" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="123b72da-6397-4f72-b5d3-31c19f66d950" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="5d12c45f-b278-413a-ad48-1b4452809356" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="5c2937a1-9e59-4fb0-a6c9-d061b5e57bc4" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="81e615db-2e7f-4d5b-8284-bf24583c461c" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>I7)
(Dec 9 is what it looks like in the cell it comes from "I7")
So the <gs id="9f5455cd-12c7-4263-a4b1-a53dc02b7eb3" ginger_software_uiphraseguid="68b54984-290e-400b-be91-1815ecc6b824" class="GINGER_SOFTWARE_mark"><gs id="f5a640f3-4698-4a04-af31-2f1ddde0d192" ginger_software_uiphraseguid="32b01e04-422e-4b70-a9fa-5397a2218ecc" class="GINGER_SOFTWARE_mark">header</gs></gs> <gs id="bd3a62a5-79b3-43cf-91b6-63f77eb3b20b" ginger_software_uiphraseguid="68b54984-290e-400b-be91-1815ecc6b824" class="GINGER_SOFTWARE_mark"><gs id="50b3083d-3dc8-4abe-8e92-9e92b849b04d" ginger_software_uiphraseguid="32b01e04-422e-4b70-a9fa-5397a2218ecc" class="GINGER_SOFTWARE_mark">for</gs></gs> the week would then look like this
Dec 3-Dec 9
<gs id="9f36d819-e854-4af9-a4e8-96d2972acd3d" ginger_software_uiphraseguid="d630117b-e403-418d-b6e0-2c4c30b3bb7f" class="GINGER_SOFTWARE_mark"><gs id="fb8e3aed-0e80-40bf-b98f-589bdb99f1d6" ginger_software_uiphraseguid="65a40645-ebc0-450f-a64f-f85e10e59279" class="GINGER_SOFTWARE_mark">partly</gs></gs> retrieved from the tab title and partly from the last day of the week.
The first date for the week I've <gs id="a8171df0-9615-4dc3-8b96-9f2a0f405a77" ginger_software_uiphraseguid="97445247-adbc-498e-8e73-19e4148183e8" class="GINGER_SOFTWARE_mark"><gs id="8bb3e780-69a0-43d8-831f-528440b8d899" ginger_software_uiphraseguid="37b95eb6-fe37-4b68-a374-6935cf327bce" class="GINGER_SOFTWARE_mark">got</gs></gs> by using this
=LEFT<gs id="50ee07d3-bf4c-4779-bedf-59505dd5f57d" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="cc160ead-c9a1-411e-8205-d3ae2050c634" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">(</gs></gs>B1<gs id="c3a09705-7452-4437-966a-37ae433aa32b" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="fad853c4-e5c4-43db-83cd-420b57c12748" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">,</gs></gs>5) which extracts the first date <gs id="fe4e83a7-da7e-4ba0-9c31-463ca681c1f1" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="b9ca0f7c-8006-4df7-9214-7f61e26f9e71" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">from</gs></gs> the tab title. The subsequent dates populate relative to that with this
=1+C7 (The first date)
<gs id="ab3deb44-ccbe-463d-8a08-b24f8bf465a4" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="4fd12328-08d9-420d-b7a1-5b61ba841d49" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">BTW what</gs></gs> I'm doing currently isn't ideal either I would MUCH RATHER be able to use the data from the tab title in the weekly header <gs id="ef6fc593-3c02-4532-998d-f4479b18de2e" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="33bf47b1-4818-4b45-8d21-62230f9f20a2" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">directly but</gs></gs> I don't know what formula to use to extricate the first part of the tab title <gs id="59537c0f-9fed-431d-9dee-a27753fd5905" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="e9a1c1be-1b68-4cc8-ad10-1039a525038c" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">ie</gs></gs>: Dec 3 directly so I'm doing it this roundabout way. If someone knows the way to use the tab name in a formula so I can reference the tab name directly using something like this formula
=MID<gs id="af1ee095-9867-4c72-a650-f62e96ade653" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="f268ca0f-f22a-42d8-a107-089f019a8926" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>CELL<gs id="f7b9596c-003c-480a-8479-fa99751bb91d" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="79baa091-85e9-4a06-8db9-c7a0d5b50fe0" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="c7a6100c-934a-4416-a381-726e08edfbe3" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="fea16d25-caaa-4cbf-9218-506727f02a12" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="50147e77-c88a-4a22-8f1c-c4fa49765147" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="c0762707-243f-4537-b146-829a53291acb" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>FIND<gs id="b629ea29-e271-4cd1-9606-cb200bc612d4" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="9f1f435e-244b-43e1-abe9-76ab6a0c0e26" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"]"<gs id="81e6309e-3329-409c-a34d-d4660b4c57b4" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="98e97a39-32bb-4a71-b90e-a23bee7ad5bf" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>CELL<gs id="e423ccef-d04e-481b-bdf1-e431aa7637e7" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="522dce31-cc33-41e4-8b7b-a17a601f74b7" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="30401dbc-fa67-45c9-907d-616a0954b020" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="5fc13332-cbcf-43f7-b57a-8bc6465cd8c1" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="27882cae-32b6-4b83-8dd1-ff76e5fbbb6c" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="6b6ce5ec-9b54-4a80-9e80-d6c83b17da6c" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">)</gs></gs>+1,255)
<gs id="7f235624-8387-4d54-ac26-f83eead91a87" ginger_software_uiphraseguid="1c22a97c-b625-47a2-b729-c15a3f75594c" class="GINGER_SOFTWARE_mark"><gs id="4739f980-198d-42b8-9e65-09024916fc1d" ginger_software_uiphraseguid="3530a1e0-c53f-414d-b771-635890ddc624" class="GINGER_SOFTWARE_mark">or</gs></gs> using this formula to extricate the first part and also add the second part (The week ending date) it would be AWESOME.
<gs id="76bea826-2dd4-47a8-aa32-f7df3faf3815" ginger_software_uiphraseguid="5bf3dcd6-4943-4e6d-810f-68b656b153e1" class="GINGER_SOFTWARE_mark"><gs id="75b32dcb-da11-4fcc-bc30-c321ea1ba526" ginger_software_uiphraseguid="088f93bb-907d-47af-bbd2-ed5828223bd8" class="GINGER_SOFTWARE_mark">Also I</gs></gs> want this workbook to be pretty much automated since the individuals who use it in the future don't know anything about spreadsheets and they're going to be making a copy of a <gs id="0436bfe9-a57e-4368-8986-1d95302164f5" ginger_software_uiphraseguid="5bf3dcd6-4943-4e6d-810f-68b656b153e1" class="GINGER_SOFTWARE_mark"><gs id="e51c393d-1c4e-4f51-aa72-4eb5e4d48ab0" ginger_software_uiphraseguid="088f93bb-907d-47af-bbd2-ed5828223bd8" class="GINGER_SOFTWARE_mark">preceeding</gs></gs> sheet for subsequent sheets so it must work in all scenarios so one issue I have is I'm extracting the beginning of the tab title with this
(LEFT<gs id="8cb8803b-340f-4dc6-a751-70043ec79ba0" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="6b9c13f5-386b-4090-a424-e4f30489a849" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="cc5dd606-8381-4920-9b9c-d64d6964545d" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="5938a7a6-203b-4261-b34f-5e3452beedba" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">,</gs></gs>4)) or (LEFT<gs id="fe3c2360-170a-4691-badc-df49818eb423" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="8c6fb552-cbaf-44f7-87c3-b5cc8ad12b17" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="a2235ce8-1880-4d1d-8ce8-a4840ddcec0a" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="37a07fa8-4949-40ea-9410-1047fef30920" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">,</gs></gs>5)) if I take the day as well as the month from the tab title. <gs id="1e1d7e42-152c-4925-8c09-ddbe3081c58a" ginger_software_uiphraseguid="55e10054-7a09-46c3-9e4f-c9d4598d322b" class="GINGER_SOFTWARE_mark">The</gs> problem with this is it only works if the first date in the period is a single digit. As soon as it starts with a 10 or greater I've <gs id="3da7440d-a83a-4222-ae8d-86b39bafdd5c" ginger_software_uiphraseguid="9bad0ef1-806b-4dba-987b-f2b375935138" class="GINGER_SOFTWARE_mark"><gs id="ab3bb889-69cd-48c1-b1f1-137110f78904" ginger_software_uiphraseguid="2218390e-fc2d-4951-a428-c358ca433e79" class="GINGER_SOFTWARE_mark">gotta</gs></gs> adapt the formula to
(LEFT<gs id="f2cda721-23db-443d-8d8a-2c62e36637ec" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="a9ec51a6-3b0c-4d67-a8bf-e973371a5d76" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="13102ad6-1e88-4dd4-9ea4-9d41f70b035e" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="3ba69976-6d52-4d42-b670-dacbe86aaada" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">,</gs></gs>5)) or (LEFT<gs id="f2cda721-23db-443d-8d8a-2c62e36637ec" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="206dcc23-192b-4316-92d3-0b85d84cbb63" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="13102ad6-1e88-4dd4-9ea4-9d41f70b035e" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="d1fbe1b0-fe6c-4c0f-bf89-6d7482a4ba17" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">,</gs></gs>6))<gs id="b4fbef38-c549-4a0b-bda2-aef5ed08d850" ginger_software_uiphraseguid="b2ba3d7a-fefe-4400-a4bb-017cea4f1fc3" class="GINGER_SOFTWARE_mark"><gs id="9e799a91-9b61-44fc-a380-5c7f725163bd" ginger_software_uiphraseguid="c487b756-2c82-43b4-a969-102c5f3a0c6f" class="GINGER_SOFTWARE_mark">which</gs></gs> isn't ideal since they won't know they have to do that for subsequent periods so I really need a way that the formula will be smart enough that if the period starts with a single digit day it will extract a single digit and <gs id="5d225332-b2eb-489e-86e4-2908c22a9db9" ginger_software_uiphraseguid="b2ba3d7a-fefe-4400-a4bb-017cea4f1fc3" class="GINGER_SOFTWARE_mark"><gs id="b024be97-b823-4ac2-aca4-01e5e330562d" ginger_software_uiphraseguid="c487b756-2c82-43b4-a969-102c5f3a0c6f" class="GINGER_SOFTWARE_mark">if</gs></gs> starts with a double digit day it will extract double digits.
I can see a similar issue in the future when the month abbreviation is 4 characters instead of 3 like Sept. Is there a way to fix this. I tried to do it by extracting everything in front of the <gs id="bb6773c2-5a01-429c-a0fb-734c806cdfac" ginger_software_uiphraseguid="be3bbf1b-b81a-418a-aad8-42f099f94162" class="GINGER_SOFTWARE_mark"><gs id="d8e0ad7f-4bcd-4721-aa35-5516a81b53d3" ginger_software_uiphraseguid="2eea3fe9-9045-4aef-a29a-2ee7734f1f87" class="GINGER_SOFTWARE_mark">hyphen which</gs></gs> would fix both issues but couldn't get it quite right.
Thanks in advance for any assistance <gs id="c6ed238a-c401-4673-bc9e-ad9651f1ff1c" ginger_software_uiphraseguid="f05d3ce3-477d-4dac-8bba-e6d1e8be24de" class="GINGER_SOFTWARE_mark">anyone</gs> can provide.
For <gs id="0535a48d-90b5-41f1-bd1f-8937bc74bf71" ginger_software_uiphraseguid="fe24fb72-3120-4806-b946-c6914aaa555b" class="GINGER_SOFTWARE_mark">example, one</gs> tab is named Dec 3-16 (This is a 2 week schedule)
The header <gs id="50a417db-7f5a-4835-8550-723d1aa5b313" ginger_software_uiphraseguid="14131413-9540-4971-bdd8-9fa42a6e58a4" class="GINGER_SOFTWARE_mark"><gs id="58ba230e-24cb-4af9-8f8d-0005a9d22933" ginger_software_uiphraseguid="0ac46178-07b4-4cda-b5bb-9aa4947d50e6" class="GINGER_SOFTWARE_mark">for</gs></gs> the week should be Dec 3-9
I've done that with this with
=CONCATENATE<gs id="68129b4d-3e9e-47c4-b16a-3c5b5fc5829a" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="1aac5375-291a-4911-8669-36ae1cb75196" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="699cf70c-8d96-483b-91d7-c7166e713d0c" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="b1c55003-7bd8-4847-b739-c0a367c2069c" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="fbc2b350-df45-44ae-8a8c-6c55f0ae70fa" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="daa6191a-d82b-4cf3-b456-03c92a485c8b" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="5cff35e6-7130-46cf-98c9-3323a204443b" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="6c524c5d-6847-4254-b5ef-32ecff6064db" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="4da3a8cd-8e28-416e-9acd-ed338fea6479" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="2f5c8e83-e98f-451a-b75a-72ef3734fcb5" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="af7bc508-7e33-4760-a303-9ab7bb8e0fe3" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="d545689e-e126-41f7-95fa-1c2bf6466492" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="a6b1b089-45a1-4ed0-9333-c6f1080e4b5f" ginger_software_uiphraseguid="5148aeea-44c2-4b6e-bdca-60eb7ba0612f" class="GINGER_SOFTWARE_mark"><gs id="1994f809-1579-4938-91ed-02f2db4246ac" ginger_software_uiphraseguid="dbaaba4f-2f5f-4b73-bc10-d720d58c4f72" class="GINGER_SOFTWARE_mark">,</gs></gs>I7)
Which comes from a cell (B1) not in the print <gs id="96120759-c473-47bd-a1fe-4d7edd5befc8" ginger_software_uiphraseguid="5fda41ec-bee8-4e63-a145-4b4390449850" class="GINGER_SOFTWARE_mark">area</gs> which gets <gs id="bcf6db2a-7740-40cd-bc76-f49b924b24c3" ginger_software_uiphraseguid="59ac0fe0-3c9d-421f-bd67-3fecdf7bcab9" class="GINGER_SOFTWARE_mark"><gs id="e39b1257-9d56-4592-8985-8aa0c89c4c16" ginger_software_uiphraseguid="15980a93-97e2-433a-bbcd-e8ddd99aab2b" class="GINGER_SOFTWARE_mark">it's</gs></gs> data from the tab title with this
=MID<gs id="8e535ada-7d7a-4109-98d4-96f6b78bcbb4" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="45e6fadc-42ee-41a7-954d-52ea2f83db3e" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>CELL<gs id="75b98a8f-4cb8-4890-ab6e-a59ee437643b" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="7d25e16f-2cff-40aa-9d41-425084ce6234" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="d7bd27a4-df62-49eb-9124-d42cbf2d260b" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="46c7b98e-c7b5-4a80-a27b-075d3cd11646" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="3f099418-d05f-4240-90dc-1ea4aad06df9" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="545702dc-5166-401e-adae-6bda4b6ba44b" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>FIND<gs id="b6338a29-63d6-414a-be0a-8186f5c69838" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="83be9725-94dd-4d00-a123-7bdd5360452c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"]"<gs id="7d28035c-854d-47b1-b6dd-caf9ed89497a" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="e7280cc9-86af-4c78-8a9b-dfd1b141deb4" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>CELL<gs id="bade118a-ad34-451d-9cc1-50021f38efcf" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="5c796926-54ba-4a4b-ac53-e828c72c638a" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="3108b776-7bd6-4135-bd78-83878ad996c2" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="e83895ea-b18a-414b-835d-e6cb66b2954c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="f7cd9d44-9242-489c-9d0a-84b16470374e" ginger_software_uiphraseguid="f9f364e2-ac10-44f1-8a4f-fe5c4693de20" class="GINGER_SOFTWARE_mark"><gs id="02d151e0-50b7-4380-a88b-ce1c73b6a72c" ginger_software_uiphraseguid="81da6dae-263a-4470-8ef9-a9fddaac30be" class="GINGER_SOFTWARE_mark">)</gs></gs>+1,255)
<gs id="36862a83-e533-4b56-8a78-f4ca1adee179" ginger_software_uiphraseguid="b180d4aa-a55d-4a2f-b069-ca6d3d3a064e" class="GINGER_SOFTWARE_mark">This </gs>renders as Dec 3-16 <gs id="3e789486-22d5-40cd-a2ab-9bfb3a16a437" ginger_software_uiphraseguid="0112e147-c30d-4253-919d-058abf978154" class="GINGER_SOFTWARE_mark">which</gs> is the exact name of the <gs id="cde205a5-e822-4166-ad88-c466645852f0" ginger_software_uiphraseguid="b180d4aa-a55d-4a2f-b069-ca6d3d3a064e" class="GINGER_SOFTWARE_mark">tab</gs>
<gs id="f339d12f-62ea-43f6-b62c-48c0685ca502" ginger_software_uiphraseguid="7c389583-5353-48d3-998a-e8eaffd0638e" class="GINGER_SOFTWARE_mark"><gs id="aa729d10-6afe-4423-976c-983ee5b9dac1" ginger_software_uiphraseguid="699b0f4c-73ca-443e-acf0-7ef56cd22c20" class="GINGER_SOFTWARE_mark">however</gs></gs> the heading for the week should be Dec 3-9 not Dec 3-16 since that's for two weeks. What I need to do is extricate the first part of the tab name <gs id="e44f6f95-62ff-4ed3-9668-af8ce44b3f95" ginger_software_uiphraseguid="38e8199b-585b-453f-a231-448899db495b" class="GINGER_SOFTWARE_mark"><gs id="dac2bfaa-5ed1-42d1-a6b9-3b16f675e323" ginger_software_uiphraseguid="db305051-e860-4617-8c6d-fd5dce19e40b" class="GINGER_SOFTWARE_mark">ie</gs></gs> Dec 3- and then I need to get the value Dec 9 from somewhere. I've tried it using this
=CONCATENATE<gs id="12d9389c-01dd-4a84-b3de-840d30969450" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="2cdf1e73-e4dc-40e3-badb-f6ee055f5494" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="ac7a0209-b608-4114-b9de-4f7b066d7a5e" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="0bb7f1a7-6f81-4ffb-8e6f-41efe2675799" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="895370f7-a79f-4e3a-a683-602166ea8ced" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="6c475206-cee2-484d-b667-41c07d46d7d0" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="20648a21-0b75-4da0-8d7f-d08e607e5f6f" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="cf45fa88-da68-4018-8140-9853ab26e417" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="8e37f30c-b8c0-495d-ab25-918e5c28252c" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="abd37460-e0b6-4fa7-bd8c-26995c3764b9" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="c8aeccff-6492-4a23-b676-a4402ad7c529" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="ad55b77c-52a0-4f86-969b-8896b90496be" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="0157a9fc-b6c6-44d6-9fec-6a5c48af5c09" ginger_software_uiphraseguid="c229f08f-eed7-4d6a-8758-aa24c1f1615e" class="GINGER_SOFTWARE_mark"><gs id="aceccb75-e4a9-4df4-9362-6e2e42321924" ginger_software_uiphraseguid="fdd4ad94-c67d-4d31-adfd-ba964c196f65" class="GINGER_SOFTWARE_mark">,</gs></gs>I7) I7 is from the column header of the last day of the week but the formatting isn't coming with it so it renders like this
Dec 3-43078 which is the date code for the <gs id="fb357ca5-b5a0-4ec6-bb29-847ff942696e" ginger_software_uiphraseguid="e7dcb3d3-190b-4ae3-a6e8-49ebeb9e5d61" class="GINGER_SOFTWARE_mark"><gs id="41ca3cd6-89a6-4a89-9d6e-cbc877588607" ginger_software_uiphraseguid="2a16b7e4-0483-4b9d-ba67-27f7024b1491" class="GINGER_SOFTWARE_mark">date not</gs></gs> exactly what I need
I need help to turn this date code into the corresponding date formatted Dec 9 within the cell code
=CONCATENATE<gs id="28f36dd7-4e36-4883-865f-340a579fd31c" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="24255f1e-ee50-4dce-9be6-c37f6d669199" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>(LEFT<gs id="4383e351-40a4-4ba0-a3e3-1e7729ea9796" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="0f83ea97-d8fb-4593-bbed-cf80aac3fc88" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="2f4ec75d-ee6a-4ba7-ac2d-e996f2a80a68" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="e1486690-a0a6-44bb-bcfb-c97ac056ba5b" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>4))<gs id="430d1574-cdf1-4c81-b622-e14807aef667" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="0bc4c606-9fc9-43de-a5a4-66749f40d871" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>(MID<gs id="69b13eed-c161-405b-bbeb-ae82f8194c78" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="d9f529bc-9152-4752-ba2e-38ab2108fe78" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="123b72da-6397-4f72-b5d3-31c19f66d950" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="5d12c45f-b278-413a-ad48-1b4452809356" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>5,1)),"-"<gs id="5c2937a1-9e59-4fb0-a6c9-d061b5e57bc4" ginger_software_uiphraseguid="e25ad217-6302-48ed-8607-543cfef819bc" class="GINGER_SOFTWARE_mark"><gs id="81e615db-2e7f-4d5b-8284-bf24583c461c" ginger_software_uiphraseguid="ab6b001c-0814-4548-a7f9-93a4b134e63f" class="GINGER_SOFTWARE_mark">,</gs></gs>I7)
(Dec 9 is what it looks like in the cell it comes from "I7")
So the <gs id="9f5455cd-12c7-4263-a4b1-a53dc02b7eb3" ginger_software_uiphraseguid="68b54984-290e-400b-be91-1815ecc6b824" class="GINGER_SOFTWARE_mark"><gs id="f5a640f3-4698-4a04-af31-2f1ddde0d192" ginger_software_uiphraseguid="32b01e04-422e-4b70-a9fa-5397a2218ecc" class="GINGER_SOFTWARE_mark">header</gs></gs> <gs id="bd3a62a5-79b3-43cf-91b6-63f77eb3b20b" ginger_software_uiphraseguid="68b54984-290e-400b-be91-1815ecc6b824" class="GINGER_SOFTWARE_mark"><gs id="50b3083d-3dc8-4abe-8e92-9e92b849b04d" ginger_software_uiphraseguid="32b01e04-422e-4b70-a9fa-5397a2218ecc" class="GINGER_SOFTWARE_mark">for</gs></gs> the week would then look like this
Dec 3-Dec 9
<gs id="9f36d819-e854-4af9-a4e8-96d2972acd3d" ginger_software_uiphraseguid="d630117b-e403-418d-b6e0-2c4c30b3bb7f" class="GINGER_SOFTWARE_mark"><gs id="fb8e3aed-0e80-40bf-b98f-589bdb99f1d6" ginger_software_uiphraseguid="65a40645-ebc0-450f-a64f-f85e10e59279" class="GINGER_SOFTWARE_mark">partly</gs></gs> retrieved from the tab title and partly from the last day of the week.
The first date for the week I've <gs id="a8171df0-9615-4dc3-8b96-9f2a0f405a77" ginger_software_uiphraseguid="97445247-adbc-498e-8e73-19e4148183e8" class="GINGER_SOFTWARE_mark"><gs id="8bb3e780-69a0-43d8-831f-528440b8d899" ginger_software_uiphraseguid="37b95eb6-fe37-4b68-a374-6935cf327bce" class="GINGER_SOFTWARE_mark">got</gs></gs> by using this
=LEFT<gs id="50ee07d3-bf4c-4779-bedf-59505dd5f57d" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="cc160ead-c9a1-411e-8205-d3ae2050c634" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">(</gs></gs>B1<gs id="c3a09705-7452-4437-966a-37ae433aa32b" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="fad853c4-e5c4-43db-83cd-420b57c12748" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">,</gs></gs>5) which extracts the first date <gs id="fe4e83a7-da7e-4ba0-9c31-463ca681c1f1" ginger_software_uiphraseguid="1a167082-2681-4332-a855-dbb4cf8ca816" class="GINGER_SOFTWARE_mark"><gs id="b9ca0f7c-8006-4df7-9214-7f61e26f9e71" ginger_software_uiphraseguid="55fed2fc-603c-4ea1-999e-3c28284c3790" class="GINGER_SOFTWARE_mark">from</gs></gs> the tab title. The subsequent dates populate relative to that with this
=1+C7 (The first date)
<gs id="ab3deb44-ccbe-463d-8a08-b24f8bf465a4" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="4fd12328-08d9-420d-b7a1-5b61ba841d49" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">BTW what</gs></gs> I'm doing currently isn't ideal either I would MUCH RATHER be able to use the data from the tab title in the weekly header <gs id="ef6fc593-3c02-4532-998d-f4479b18de2e" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="33bf47b1-4818-4b45-8d21-62230f9f20a2" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">directly but</gs></gs> I don't know what formula to use to extricate the first part of the tab title <gs id="59537c0f-9fed-431d-9dee-a27753fd5905" ginger_software_uiphraseguid="dc3b7ebe-b40b-43f7-980c-b42be7998c40" class="GINGER_SOFTWARE_mark"><gs id="e9a1c1be-1b68-4cc8-ad10-1039a525038c" ginger_software_uiphraseguid="7c382447-db7f-4f8f-b3a4-d898ea97c4a5" class="GINGER_SOFTWARE_mark">ie</gs></gs>: Dec 3 directly so I'm doing it this roundabout way. If someone knows the way to use the tab name in a formula so I can reference the tab name directly using something like this formula
=MID<gs id="af1ee095-9867-4c72-a650-f62e96ade653" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="f268ca0f-f22a-42d8-a107-089f019a8926" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>CELL<gs id="f7b9596c-003c-480a-8479-fa99751bb91d" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="79baa091-85e9-4a06-8db9-c7a0d5b50fe0" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="c7a6100c-934a-4416-a381-726e08edfbe3" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="fea16d25-caaa-4cbf-9218-506727f02a12" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="50147e77-c88a-4a22-8f1c-c4fa49765147" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="c0762707-243f-4537-b146-829a53291acb" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>FIND<gs id="b629ea29-e271-4cd1-9606-cb200bc612d4" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="9f1f435e-244b-43e1-abe9-76ab6a0c0e26" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"]"<gs id="81e6309e-3329-409c-a34d-d4660b4c57b4" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="98e97a39-32bb-4a71-b90e-a23bee7ad5bf" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>CELL<gs id="e423ccef-d04e-481b-bdf1-e431aa7637e7" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="522dce31-cc33-41e4-8b7b-a17a601f74b7" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">(</gs></gs>"filename"<gs id="30401dbc-fa67-45c9-907d-616a0954b020" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="5fc13332-cbcf-43f7-b57a-8bc6465cd8c1" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">,</gs></gs>A1)<gs id="27882cae-32b6-4b83-8dd1-ff76e5fbbb6c" ginger_software_uiphraseguid="f4a9bee5-cbf8-4270-9d31-205d901e97fa" class="GINGER_SOFTWARE_mark"><gs id="6b6ce5ec-9b54-4a80-9e80-d6c83b17da6c" ginger_software_uiphraseguid="ea2b1652-061d-42d5-a556-58b8a99c6e9e" class="GINGER_SOFTWARE_mark">)</gs></gs>+1,255)
<gs id="7f235624-8387-4d54-ac26-f83eead91a87" ginger_software_uiphraseguid="1c22a97c-b625-47a2-b729-c15a3f75594c" class="GINGER_SOFTWARE_mark"><gs id="4739f980-198d-42b8-9e65-09024916fc1d" ginger_software_uiphraseguid="3530a1e0-c53f-414d-b771-635890ddc624" class="GINGER_SOFTWARE_mark">or</gs></gs> using this formula to extricate the first part and also add the second part (The week ending date) it would be AWESOME.
<gs id="76bea826-2dd4-47a8-aa32-f7df3faf3815" ginger_software_uiphraseguid="5bf3dcd6-4943-4e6d-810f-68b656b153e1" class="GINGER_SOFTWARE_mark"><gs id="75b32dcb-da11-4fcc-bc30-c321ea1ba526" ginger_software_uiphraseguid="088f93bb-907d-47af-bbd2-ed5828223bd8" class="GINGER_SOFTWARE_mark">Also I</gs></gs> want this workbook to be pretty much automated since the individuals who use it in the future don't know anything about spreadsheets and they're going to be making a copy of a <gs id="0436bfe9-a57e-4368-8986-1d95302164f5" ginger_software_uiphraseguid="5bf3dcd6-4943-4e6d-810f-68b656b153e1" class="GINGER_SOFTWARE_mark"><gs id="e51c393d-1c4e-4f51-aa72-4eb5e4d48ab0" ginger_software_uiphraseguid="088f93bb-907d-47af-bbd2-ed5828223bd8" class="GINGER_SOFTWARE_mark">preceeding</gs></gs> sheet for subsequent sheets so it must work in all scenarios so one issue I have is I'm extracting the beginning of the tab title with this
(LEFT<gs id="8cb8803b-340f-4dc6-a751-70043ec79ba0" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="6b9c13f5-386b-4090-a424-e4f30489a849" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="cc5dd606-8381-4920-9b9c-d64d6964545d" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="5938a7a6-203b-4261-b34f-5e3452beedba" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">,</gs></gs>4)) or (LEFT<gs id="fe3c2360-170a-4691-badc-df49818eb423" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="8c6fb552-cbaf-44f7-87c3-b5cc8ad12b17" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="a2235ce8-1880-4d1d-8ce8-a4840ddcec0a" ginger_software_uiphraseguid="81574f23-c9e1-49dc-a542-a54fb13460b4" class="GINGER_SOFTWARE_mark"><gs id="37a07fa8-4949-40ea-9410-1047fef30920" ginger_software_uiphraseguid="96ea22d1-2def-4c7d-8026-01f3d73ebdea" class="GINGER_SOFTWARE_mark">,</gs></gs>5)) if I take the day as well as the month from the tab title. <gs id="1e1d7e42-152c-4925-8c09-ddbe3081c58a" ginger_software_uiphraseguid="55e10054-7a09-46c3-9e4f-c9d4598d322b" class="GINGER_SOFTWARE_mark">The</gs> problem with this is it only works if the first date in the period is a single digit. As soon as it starts with a 10 or greater I've <gs id="3da7440d-a83a-4222-ae8d-86b39bafdd5c" ginger_software_uiphraseguid="9bad0ef1-806b-4dba-987b-f2b375935138" class="GINGER_SOFTWARE_mark"><gs id="ab3bb889-69cd-48c1-b1f1-137110f78904" ginger_software_uiphraseguid="2218390e-fc2d-4951-a428-c358ca433e79" class="GINGER_SOFTWARE_mark">gotta</gs></gs> adapt the formula to
(LEFT<gs id="f2cda721-23db-443d-8d8a-2c62e36637ec" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="a9ec51a6-3b0c-4d67-a8bf-e973371a5d76" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="13102ad6-1e88-4dd4-9ea4-9d41f70b035e" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="3ba69976-6d52-4d42-b670-dacbe86aaada" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">,</gs></gs>5)) or (LEFT<gs id="f2cda721-23db-443d-8d8a-2c62e36637ec" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="206dcc23-192b-4316-92d3-0b85d84cbb63" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">(</gs></gs>$B$1<gs id="13102ad6-1e88-4dd4-9ea4-9d41f70b035e" ginger_software_uiphraseguid="c31554fe-394e-484a-952e-c0f94d20a8e4" class="GINGER_SOFTWARE_mark"><gs id="d1fbe1b0-fe6c-4c0f-bf89-6d7482a4ba17" ginger_software_uiphraseguid="bf1bc549-98d6-4c44-b373-d930f1e037e4" class="GINGER_SOFTWARE_mark">,</gs></gs>6))<gs id="b4fbef38-c549-4a0b-bda2-aef5ed08d850" ginger_software_uiphraseguid="b2ba3d7a-fefe-4400-a4bb-017cea4f1fc3" class="GINGER_SOFTWARE_mark"><gs id="9e799a91-9b61-44fc-a380-5c7f725163bd" ginger_software_uiphraseguid="c487b756-2c82-43b4-a969-102c5f3a0c6f" class="GINGER_SOFTWARE_mark">which</gs></gs> isn't ideal since they won't know they have to do that for subsequent periods so I really need a way that the formula will be smart enough that if the period starts with a single digit day it will extract a single digit and <gs id="5d225332-b2eb-489e-86e4-2908c22a9db9" ginger_software_uiphraseguid="b2ba3d7a-fefe-4400-a4bb-017cea4f1fc3" class="GINGER_SOFTWARE_mark"><gs id="b024be97-b823-4ac2-aca4-01e5e330562d" ginger_software_uiphraseguid="c487b756-2c82-43b4-a969-102c5f3a0c6f" class="GINGER_SOFTWARE_mark">if</gs></gs> starts with a double digit day it will extract double digits.
I can see a similar issue in the future when the month abbreviation is 4 characters instead of 3 like Sept. Is there a way to fix this. I tried to do it by extracting everything in front of the <gs id="bb6773c2-5a01-429c-a0fb-734c806cdfac" ginger_software_uiphraseguid="be3bbf1b-b81a-418a-aad8-42f099f94162" class="GINGER_SOFTWARE_mark"><gs id="d8e0ad7f-4bcd-4721-aa35-5516a81b53d3" ginger_software_uiphraseguid="2eea3fe9-9045-4aef-a29a-2ee7734f1f87" class="GINGER_SOFTWARE_mark">hyphen which</gs></gs> would fix both issues but couldn't get it quite right.
Thanks in advance for any assistance <gs id="c6ed238a-c401-4673-bc9e-ad9651f1ff1c" ginger_software_uiphraseguid="f05d3ce3-477d-4dac-8bba-e6d1e8be24de" class="GINGER_SOFTWARE_mark">anyone</gs> can provide.
