2021.10.26 00:16 paintedicecream Counting date cells in a column referencing another cell with the month as text
I have a workbook that will get copied monthly. One of the sheets will contain a cell that will require the month to be updated. I'm trying to build it so the non excel people (which I very recently was!) can just put their data in the right places and functions will complete all of the kpi collection and calculations.
One of the functions I've been trying to figure out is how to count cells in a column that match the cell with the text date in.
So it looks a little like (sorry I'm on mobile):
Month. September Tour's completed this month ?
Name Tour date. Wait listed Joe blogs. 02/09/2021. Yes
I considered asking people to only put this month's data in the sheet, however it will be a lot more convenient to have our waitlist in one place.
Each month the workbook will be saved as the next month, so tour info can just be added on and deleted if someone moves in or finds another facility etc.
Is there a way that I can reference the cell that people manually write the month into to count the number of tours completed in that month?
I just keep getting errors!
submitted by paintedicecream to excel [link] [comments]
2021.10.26 00:16 ICY_Golden I see no lies
|submitted by ICY_Golden to BrandonDE [link] [comments]|
2021.10.26 00:16 devintheedivine How To Get A Free Gift On Top Hatter
|submitted by devintheedivine to SideHustleSchool [link] [comments]|
2021.10.26 00:16 GarlicMindless How do I fix the back puffy part of my hair
|submitted by GarlicMindless to Hair [link] [comments]|
2021.10.26 00:16 labinnacotua Does anybody remember u/Istanpegasus
2021.10.26 00:16 Quirky-Address-3350 Go put your hand on a stove.
2021.10.26 00:16 UpbeatRiceVendor I never knew NPCs would be brave enough to fight synths only using fists
|submitted by UpbeatRiceVendor to fo4 [link] [comments]|
2021.10.26 00:16 eldridge2e Obviously there's no Freak Fest this year, so what is everyone doing on Saturday night?
2021.10.26 00:16 privkry Should i lvl water kung fu first or venom
2021.10.26 00:16 moneyman_15 Earnings nov 8
Not financial advice. I see this as a huge opportunity for Riot to show us exactly what they’ve been doing last quarter and to turn some eyes toward this stock. We might not follow Bitcoin exactly at this point but I see no reason it can’t follow it on a lower scale
submitted by moneyman_15 to Riot [link] [comments]
2021.10.26 00:16 tim78rpm 24 slot S class slate blue Experimental rifle multi tool, with raised tubes/wires and off white decals.
|submitted by tim78rpm to NMSCoordinateExchange [link] [comments]|
2021.10.26 00:16 stoka0 Okuninushi Showcase
|submitted by stoka0 to Megaten [link] [comments]|
2021.10.26 00:16 Dhondoe99 DEATHLOOP : $37.19 (-38%)
|submitted by Dhondoe99 to SmartGamingDeals [link] [comments]|
2021.10.26 00:16 pinchevatobarbon Chewing food with your mouth closed is as annoying for others as it is to chew with your mouth closed.
I am sitting at the table, just me, my sister and her cat laying besides her chair. My sister is eating, while there’s seconds of complete silence in which I could hear her, from across the table, chewing her fucking food. I hate it. Ima just dip now...
submitted by pinchevatobarbon to unpopularopinion [link] [comments]
2021.10.26 00:16 Mike_Wahlberg Darkrai taking 10, 1746 0736 6106
|submitted by Mike_Wahlberg to PokemonGoRaids [link] [comments]|
2021.10.26 00:16 East_Ad909 My game crashes 🤦♂️
2021.10.26 00:16 southernhides Bevel Hexagon Cowhide Rug - Hexagon Pattern https://t.co/2gAnk5YdCD #HexagonShape #10x14rug #DesignerCowhideRug #GeometricHexagon #ContrastColors #HexagonalPattern #BevelHexagon #OneOfaKindRug #BeveledPattern #DesignAreaRug #HoneycombAreaRug #12x15rug #ContemporaryRug https://t.co/EsSVaIp9fY
|submitted by southernhides to southernhides [link] [comments]|
2021.10.26 00:16 Ahmed_Omar12 PlayStation Jungle T-Shirt Officially Licensed $21.99 Amazon
|submitted by Ahmed_Omar12 to SmartGamingDeals [link] [comments]|
2021.10.26 00:16 cutemermaidaqua I can’t do this anymore… my parents don’t help at all I’ve tried to tell them I need help 3 different times.
(Told then I might have social anxiety) The first 2 times I told them through messages and 10 min ago I gathered the courage to tell them again maybe this time they would understand, well they didn’t.
They keep saying to just talk, that I’m choosing to be this way, that it isin’t that hard, that there is no book to tell you how to talk you just gotta do it.
Then I told them I need a therapist but they said that’s why you have your dog, they are very therapeutic and they lisen and don’t judge… and that god is the best therapist, I agree but I feel like I need to do more too. I told them like 4 times I need a therapist and they kept rejecting the idea. They think I’m dumb and crazy. Then I finally gave up and told them “I’m never gonna tell y’all anything again, y’all don’t help” and they said “we are listening to you and helping” And I said “if you really wanted to help y’all would take me to a therapist” then I said “can I go to sleep now” and finally came back to my room where I currently am (before I came I screamed “THANKS” in the lost sarcastic way possible cause they obviously didn’t help at all now I feel even worse. Tomorrow I might go see my school counselor to talk to her about this.
submitted by cutemermaidaqua to teenagers [link] [comments]
2021.10.26 00:16 mila_z Looking for | K | Christy | Jinny | Autumn | Vanesa | Delilah | Evelyn | Ariel | Eliza | and the rest of our FM group! We are a group of 6 and we are looking to tie for first with you!!!
2021.10.26 00:16 Dr_Shrimp_PuertoRic0 Any Love for Tudor?
Hey everyone! Been poking around for a little bit and I see all the talks of Rolex but wanted to know if anyone has any experience with Tudor reps. I'm particularly interested in the new Black Bay Chrono but not seeing them anywhere (within the TD's I've seen).
Sorry in advance is this isn't something I should be posting. I saw its against the rules to ask whats the best ______ but Tudor didn't seem to be on that list. Thanks in advance! :)
submitted by Dr_Shrimp_PuertoRic0 to RepTime [link] [comments]
2021.10.26 00:16 arihimym [o levels] considering skipping pure chem paper
i have been getting d7 and below consistently for chem since sec 3. okay actually for sec 3 overall i got b4 but for prelims i literally got f9. i don't really feel motivated to revise cause i don't think much can be done at this point. therefore i have resorted to the plan of skipping the paper but i'm worried abt how it will be reflected on my cert. correct me if i'm wrong but i think chem will be marked as 'abs'? for those who skipped a paper, were there any consequences? could you guys give some advice or words of encouragement?
submitted by arihimym to SGExams [link] [comments]
2021.10.26 00:16 picklepowerPB Hank Hat!
Hi everyone! New to the sub, but not new to TWY at all. I have a question for y’all.
I lost my favorite beanie saturday night. Its the maroon one with a little white Hank on the front.
At a bar it fell off the table and we were on our way out so couldn’t look for it. The bar didn’t find it either, I’ve been asking.
Does anyone here know where to get a replacement, or would be willing to sell me one? This was my favorite hat on the planet, there’s nowhere to buy it online that I’ve found, so I was hoping someone here might know what I could do.
Thank you all!
submitted by picklepowerPB to TheWonderYearsMusic [link] [comments]
2021.10.26 00:16 Trumpjet It’s all fun and games until this happens
|submitted by Trumpjet to dankmemes [link] [comments]|
2021.10.26 00:16 Chizuru_San Is it better to use copper anti size for brake job?
I am using a Permatex Anti-Seize with temperature Range: -80°F to 1600°F (-51°C to 871°C)
I just found there is Permatex Copper Anti-Size available with higher temperature Range up to 1800°F (980°C)
Is it better for brake job? Or just doesn't matter? Thanks.
submitted by Chizuru_San to MechanicAdvice [link] [comments]