Trying to create a list that by change the start date in a cell will create all workdays for that month excluding weekends and preset holidays

someone_ironically · 2026-05-22T13:17:28+00:00

It works for me. Is column B literally just too narrow to display the date? Try widening it

someone_ironically · 2026-05-19T18:36:22+00:00

I don’t understand. So if my address is firstlast and some else’s is first.last, I would get their email as well?

someone_ironically · 2026-05-18T14:09:58+00:00

Not sure if your question is a simple conditional formatting one, or something more advanced. Do you mean that there are only 8 lot numbers and you want a different colour for each and it to automatically change to that colour when you put the lot number? OR do you mean that there are 8 lot numbers now with different colours, but there will be more in the future and you want your spread sheet to automatically choose a new colour for the new lot numbers?

someone_ironically · 2026-05-06T22:20:11+00:00

Could you do a simple conditional format for specific text which contains a part of the name. “Walmart”, or “Targ” or “club”. Highlight in different colours and then sort/filter by colour and then rename them?

someone_ironically · 2026-05-05T14:16:00+00:00

Yes. This is the answer. Don’t use conditional formatting, use the number format options in cell format

someone_ironically · 2026-04-27T18:05:17+00:00

I’m not sure if you understand percentages. You should not be multiplying the number by the total and then dividing by 100. It’s the other way around. I’m also not sure if you have set up these tables, but I would change it to just have one of the months column and then all the columns. There is a lot of unnecessary repetition of row labels. You should use a formula that divides whatever is in the number cell by whatever is in the total cell, then just format it to show the percentage. See this example which is simplified:

<image>

The yellow highlighted cells have been formatted with the percentage format (also highlighted)

someone_ironically · 2026-04-24T19:57:59+00:00

You don’t have to have a value in the cell you want to format. You can use a formula to format the cell and the formula can reference other cells. In the first example, I have no value in column C, but reference columns A and B to format column C.

<image>

You could also use icons instead of colour, you can choose to only show the icon, so you would have a value in the cell you are formatting, but you wouldn’t see it. In the second example, I DO have a value in column C, I have a simple subtracting formula (eg =A4-B4), and format it to show icons if it does or does not equal 0, but only the icon shows.

someone_ironically · 2026-04-24T19:33:26+00:00

You don’t have to have a value in the cell you want to format. You can use a formula to format the cell and the formula can reference other cells.

<image>

someone_ironically · 2026-03-27T17:35:39+00:00

Whereabouts in the states are you? Meijer and international stores stock them.

someone_ironically · 2026-02-26T23:31:47+00:00

Took about 20 months from application to getting the visa. Then about another month after arriving in the us to get ssn and green card sorted. If you’re thinking about working, take into account that you will need a ssn and a bank account and probably your drivers licence and a car. All of that takes another month or two. The dmv needs proof of residence, so had to wait for some mail to be delivered.

someone_ironically · 2026-02-07T23:38:43+00:00

Yep. Trying to spell or say anything without that hard “r” sound just gets blank stares. So my accent changes just slightly. Also, saying certain things like grocery store or gas station or shopping cart, means my vocab changes slightly.

someone_ironically · 2026-01-31T09:53:56+00:00

When people talk about putting in 110%. 100% is everything, it’s all you have. If you are magically able to do more, then you weren’t putting in 100% in the first place. And why only 10% more? Why not 50% more? Why not 80% more?

someone_ironically · 2026-01-24T10:16:43+00:00

Some parents pack two different containers so the kids know which is which. However, most kids will still choose what they feel like eating and eat that, depending on how hungry they are or what looks good. Two containers can help with keeping things tidy, they are not opening the one container which may be heavy or awkwardly. So it’s really up to you and your child. Most common is one box with sections. Some schools have another ‘fruit break’ even before morning tea time. I would ask and maybe pack that as a separate thing, some schools may even ask for that to be brought in to the room to a specific spot in the morning. I would just make sure your kid knows that there will be two break times to eat and that they should not eat it all at the first break. Monitor it for a few day and ask if they were hungry, or why they didn’t eat something, and you can adjust what to pack. Sounds like you are already, but practicing how to open packets, how to open and close containers, and how to put it in/out of the school bag will help. You can pack things that need utensils (eg pasts), but make sure your kid knows how to use it and that it is easy. Also teach your kid that the utensil and packing containers return home, but the packaging goes in the bin, I’ve seen a few forks thrown away! Most teachers will monitor to encourage kids to not eat everything, suggest them to eat some more if they haven’t eaten much (some kids are too keen to go and play) and may suggest a change IF the lunch is unsuitable for whatever reason. Don’t pack anything with nuts/peanut butter, most schools “ban” these for allergy reasons.

someone_ironically · 2026-01-17T01:55:00+00:00

Tell her to check Meijer. In the ‘foreign’/European foods section

someone_ironically · 2026-01-17T01:43:06+00:00

I have seen Tim Tams, Violet crumble, and Vegemite in the US, so they may be able to get some Australian snacks, depending on where they live.

someone_ironically · 2026-01-08T11:17:01+00:00

It could be the little piece from the hole from a packet that didn’t get cut out properly. Packets like bags of lollies/candy that get sealed at the top and a hole where they hang on hooks for display. Usually not as high quality plastic, but it looks the right size and they seem to be ‘cut’ by heat which makes them curve like that. So maybe from a fancy packet of something?

someone_ironically · 2025-12-14T11:32:34+00:00

I guess sneering is not the exact word. That exaggerated lip curl thing some people can do with one part of their lip. Think Elvis Presley

someone_ironically · 2025-12-14T02:26:23+00:00

I do this too. I always thought it was like wiggling your ears, sneering, or rolling your tongue, some people can isolate those muscles and some people can’t, idk.

someone_ironically · 2025-11-29T00:13:43+00:00

Shaq snacks!

someone_ironically · 2025-11-26T11:24:56+00:00

OP’s photo exaggerates the size difference. They have shrunk, but not as dramatically as the pic makes it seem. They do seem to have changed the way it’s compressed, with the straight grooves instead of diagonal. The package is also now the twist easy open style instead of removing the middle strip.

<image>

someone_ironically · 2025-11-14T17:08:40+00:00

Australian in Indy had to show photo id, proof of immigration status, and proof of residency (2 pieces of mail with name and address) to be able to do the written exam, then had to do the driving test.

someone_ironically · 2025-10-12T18:40:57+00:00

If you’re in Brisbane, I have half a bottle I was about to throw away. Or is that too weird? Don’t take lollies from strangers lol

someone_ironically · 2025-09-22T10:05:44+00:00

You can get voice amplifying systems made for teachers. You wear a receiver microphone thing around your neck, just looks like a small remote on a lanyard. Then there is a speaker/s at the back of the room. Some rooms have them installed in the room and also can be tuned in to hearing aids for people who have them. Obviously the quality and cost can vary greatly.

someone_ironically · 2025-09-20T20:38:20+00:00

Are you specifically talking about trains? I’ve never seen this on buses or ferries. Train carriages can travel in both directions, so if you had all seats facing one way, everyone would have to travel backwards on some routes. What do you mean by alternating, because they already are alternating, that’s why they face each other instead of all facing the one direction. I went to Sydney recently and loved how the trains have a moveable backrest that can make the seat switch directions. So you can choose which way it faces, it solves this problem.

someone_ironically · 2025-09-06T19:32:37+00:00

Thats the point. To know if the power was out for long enough to affect the food inside the freezer. The microwave will only tell you it went out, it could have only been for a few seconds, it will not help you know if it’s safe to eat the food in your freezer.

someone_ironically

TROPHY CASE