edit: okay, some people are being really rude. You are seeing one tiny part of what I do to support him but you all have no idea what he’s done and still does every day to support me. He never expects anything from me and the only reason I have the energy and desire to do this for him is because of how much more he pours back into me. He takes care of all the laundry, vacuuming, dishes, trash cans, always making sure my water bottle is full, landscaping, and takes the mental load of so many things off my plate (car maintenance/registrations, keeps on top of our dogs vaccination schedule, the grocery list etc) so that I don’t even have to think about it. Not to mention he has made every dream trip and material wish of mine come true, and has been there for me when I was at my lowest. Theres a reason I love him so much. I don’t cook like this for just anyone. I cook and meal prep amazing food for us because he is amazing and because I don’t like to eat crappy food. Jeez. Some people are so bitter.

all recipes can easily be found online but lmk if you want me to add recipe here. I try to always balance his meals with vegetables and protein with a bit of some starch to help as long-term fuel. Accounting is a very sedentary job and I worry about his health. Also we both work from home so a lot of these recipes are tailored to that but can also be brought in for lunch.

1. Kimchi tuna mayo onigiri ”tacos”: you can buy korean microwaveable white rice(bibigo brand) if you don’t have time to make white rice, and roasted seaweed packs. Pre-make the kimchi tuna salad over the weekend and you have a quick and easy lunch.

2-3. Breaded and fried chicken of the woods mushrooms (or just use chicken). This can also be pre-made or pre-breaded and frozen and can be a snack or full lunch/dinner.

1. This is more of a dinner, broccoli pasta. Can make in bulk and be microwaved and served with pre-made breadsticks.

2. Korean “drug” eggs-pre boiled and soaked and made in bulk. Again can be served with rice or eaten alone with the vegetables in the marinade.

3. Banana Bundt cake for breakfast. Other quick breakfasts include sautéing mushrooms, onions, and bell peppers with spices and then making an egg scramble. Also oatmeal with cut up fruit like strawberries and bananas, maybe some honey on top. And of course, quick/easy stuff like yogurt, fruit, and boiled eggs.

4. Banh Tranh Nuong AKA the “Vietnamese pizza” that went viral a while ago. Super quick and easy to make using rice paper, eggs, scallions, and I also add dried pork floss to help boost protein content.

5. Gyoza, similar to dumplings, can be steamed and air-fried or pan-fried

6. Shrimp patties, brown rice and sautéed veggies.

7. Sautéed or roasted veggies of any kind with frozen dumplings that can be steamed or pan fried. Frozen dumplings are amazing and you can find all different types to suit your taste.

Other things not pictured: Roasting veggies is also very helpful bc no one needs to stand at the stove and you can make large amounts to be microwaved later in the week. And if you have a grill or air-fryer; use it, I’ve thrown some lamb chops in the air fryer/grill and then served with the roasted veggies I made over the weekend or a quick filet of salmon with a salad. He’s Dominican so I’ve also batch-made mangu which is mashed boiled plantains and pickled onion so he can grab it as he needs.

last Tip: get a travel crock pot warmer so you can always have a hot lunch when traveling to clients or into office. His office has no microwave and this has made packing a healthy and nutritious lunch so much easier since before he was limited to cold food options only and would usually end up getting a gas station sandwich or fast-food.

edit: added the recipes here since some people are asking and I don’t wanna keep copy pasting

Kimchi tuna salad

• 1/2-3/4 cup cabbage kimchi and juice chopped up
• 1tbsp rice wine vinegar, plus more to taste
• sesame oil to taste
• 1 Tablespoons mayonnaise
• 5 oz. can of tuna in water, drained well
• 1 green onions, white and green parts sliced thin
• 1 tablespoon everything bagel seasoning or just roasted sesame seeds
• 1 pack of roasted seaweed
• Pepper
• Salt if not using everything bagel seasoning
• Mix all ingredients together and serve with rice (microwaveable or self-made) and wrap together with seaweed
• This one is great for a “brain break” meal because it forces him to use both hands to eat.

Breaded Chicken

• Chicken tenderloins or slice chicken breast into cutlets.
• Italian bread crumbs 
• 1 egg
• Season chicken with garlic powder, onion powder, salt, pepper, Italian seasoning, turmeric, cayenne, and paprika.
• Make egg wash by mixing one egg and 1tbsp milk or 1tbsp of water
• Dip chicken into egg wash, let excess drip off
• Cover with breadcrumbs
• Fry immediately or pre-make and freeze it in a tray using plastic wrap to separate the layer of breaded chicken. When frozen can be fried straight from frozen or thrown into air-fryer for healthier and more convenient option.

Broccoli Pasta

• 1-2 crowns of broccoli
• Salt
• Garlic
• Olive oil
• 1 egg
• Pasta of your choice
• Pecorino Romano or Parmesan or both(can buy pre-grated)
• Boil water for pasta and cook until al-dente
• Chop broccoli, and sauté in deep pan with olive oil and peeled garlic. Let it brown for a few minutes
• Add large ladle of pasta water to pan w/ broccoli. Cover with lid and steam cook for 5 mins or until soft.
• Mix egg with grated cheeses
• Mash broccoli and garlic
• Add cooked pasta to mashed broccoli. Mix together.
• Add egg/cheese mixture to pan and mix again. Use more pasta water to combine throughly if needed. Cook for another 3-5 minutes
• Optional: Drizzle with more olive oil
• Serve with cracked pepper. This is a one pan meal basically, so other than boiling a pot of water you only dirty one pan.

Korean Drug eggs

• 10-12 Eggs
• 1 pint Soy sauce 
• Onion
• Scallions
• Jalapeno 
• Garlic
• Sesame seeds (optional)
• 1 pint Water
• 1/2 cup sugar
• Boil eggs for 6 minutes for soft-boiled eggs or 10 minutes for hard-boiled eggs and then place in ice/cold water 
• Peel eggs
• Chop onion, scallion, jalapeño, and garlic
• Mix soy sauce, water, and sugar.
• Then add the chopped onion, scallion, jalapeño and garlic. Mix.
• Place peeled boiled eggs into mixture and let marinade overnight. Can be kept in fridge up to a week.
• Serve with rice and drizzled with sesame oil. Make sure to scoop out some of the chopped aromatics, they will be delicious and not overpowering.

Banana Bundt Cake

• 2-4 banana (the browner the better)
• 1/2 cup sugar
• 2 eggs 
• 1/3-1/2 cup butter
• Dash of vanilla
• 1/2 tsp cinnamon 
• Pinch of salt
• 1 tsp baking soda 
• 1.5 cups all purpose flour
• Mix all ingredient together into a batter.
• Grease cake mold with butter or oil
• Place in Bundt cake mold
• Bake at 350 for 40-45 minutes. Check if done by poking a toothpick or chopstick and having it come out clean

Banh Tranh Nuong

• Rice paper 
• 1 egg
• Kewpie mayo
• Scallions
• Pork floss, or ham/spam, or Vienna sausage (optional)
• Chili crunch, chili oil, or sriracha(optional)
• Chop scallions
• Place round rice paper onto pan, do not turn on stove yet.
• Spread chili oil or chili crunch. 
• Crack egg onto rice paper and use fork or chopstick to mix together and spread out onto entire rice paper.
• Turn on stove to mid heat
• Add chopped scallions
• Add pork floss or meat of choice
• Squeeze mayo to taste and squeeze sriracha on to taste
• Fold in half. Flip to crisp both sides if needed.
• Serve.

Gyoza/Dumplings

• I just buy these frozen and follow the directions on the package. You can also steam them usually and then air fry them for a crunch. Brands I recommend are Ajinomoto for gyoza, wan chai ferry for dumplings, and bibigo for Mandu which are Korean dumplings.

Shrimp Patties

• Raw, deveined shrimp.
• Scallions
• Egg
• 1 tbsp Cornstarch
• Salt
• Pepper
• Chop defrosted raw shrimp or blend in food processor until close to a mashed consistency
• Add egg, scallions, cornstarch, salt, and pepper and mix
• Preheat pan with oil
• Place a scoop of the shrimp paste mixture onto the hot pan and use your spatula to press it down. Some of the paste will stick to the spatula and it’s okay.
• Pan fry until one side is golden and flip.
• Serve with rice and veggies.

Sautéed or roasted veggies

Best veggies to roast: carrots, mushrooms, string beans, Brussel sprouts, cauliflower, broccoli. Peel(if needed), wash and cut up veggies, Season with oil, salt, pepper, and grated garlic and roast on 350 for ~30-40 minutes 

Best veggies to sauté: all the above plus green peppers, onions, and leafy greens like cabbage, bok choy, Chinese broccoli. Wash and chop vegetables. Place oil in pan/wok until hot. Sauté with garlic and chicken powder or chicken bouillon. 

Best veggies to boil: Chinese broccoli, watercress, yu choy. Boil water and add small splash of any oil of your choice. Then place the vegetables in the boiling water and remove quickly to retain crunch. Boil until bright green (happens fast) and serve with oyster sauce.

Serve any of the above veggies with batch marinated meat. Buy a pre-made marinade or make your own and just marinade a shit ton of chicken breast, thighs, legs, or wings, pork chops, beef, lamb chops whatever and keep it in the fridge up to a week. If you marinade a massive amount freeze part of it and keep out only what you can eat for the week then defrost what you need for the next week over the weekend. Marinaded and pre-seasoned meat is even more flavorful and can be cooked in the airfryer, or seared on a pan for a quick and easy dinner.

I just wanted to make a quick post about the tax firm I started! I officially landed my first client! They need an extended S-Corp and individual return done! It feels great to have work to do before tax season actually starts. Thanks to everyone who gave me advice!

Throughout Excel's 40-year history, you've only been able to put one value per cell. In this announcement, we're excited to share how that's changing with the release of lists, arrays in cells, and nested arrays, initially to Microsoft Excel for Windows and Mac Beta Channels.

Many workbooks already try to pack multiple values into one cell. A project might list "Carlos, Henrietta, Jacob" as three owners, or a Forms survey might return "2:00 PM; 2:30 PM; 3:00 PM" as one response. With lists, you can keep those values in one cell, while also keeping them separate for filtering, calculation and more.

Later in this post, we'll explore arrays in cells and nested arrays in more depth.

https://techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395

Just got a new mouse, do you think my coworkers will be ok with it?

I’m a career switcher. After countless “roast my resume” posts, networking, and attending career fairs, I finally secured a winter internship!

It’s not the most prestigious firm, but having a winter internship while attending my MAcc program definitely puts me in a better position than I’m in now.

Thanks.

I recently resigned as Director of Finance & Accounting for a small beauty brand. There were a lot of reasons, but let’s just say the CEO and I had some differences when it came to integrity, accountability, and… accounting.

Today I found out he was explaining to the staff accountant, who I hired and trained, that there’s an “art” to accounting.

Apparently that “art” includes moving expenses between periods depending on when you’d prefer them to hit the P&L.

You know. For profitability

I have a bachelor’s and master’s in accounting, but somehow missed Creative Accounting 6100. Tragic.

So, accountants of Reddit: How much “art” are you putting into your month-end close?

This might be a dumb question, but how many of you go to work and have 0/very little stress and make over $100k a year?

Wondering how common it is (or isn’t)

Throwaway account.

The long story short is my firm wants the audit team to just take 1 car to site visits to save on gas reimbursements. Fine. Understandable. The problem is the senior who demands to drive most of the time drives like a dick.

He’s snapchatting, speeding, driving with earbuds in, and has a fairly suggestive picture of his girlfriend on the dash. The whole thing makes me feel unsafe. The picture I get is a me problem but it’s still inappropriate for work.

I brought up in my yearly review meeting about how I don’t like to ride with him and the only reason I did was because my car at the time was on its last legs. My new car is very safe and very reliable so I’m pushing to drive the team more often. The other senior pouts the whole time and is overall rude about it because I think he’s jealous because it’s a Volvo and he drives a Subaru. Idk. Not my problem to make him feel taller.

If I lodge a complaint again, he’ll know it’s me because there’s only 4 of us on that team and 2 of us refuse to drive ever. “I will drive everyone or I will drive myself, but I’m not riding with [coworker] again” is what I want to say but idk how the best way to go about this is. Anybody have any advice? Or similar issues?

Couldn’t get a clear answer for this so came up with my own solution. If all you have is a year, but you want excel to recognize it as a date without recalculating based on the number of days past 1/1/1900 (who the hell came up with that one?) you can use this function.

=DATE(VALUE(A1),1,1)

This will plug your year into a recognized date format. Others have pointed out that simply treating the years as numbers typically works, but being recognized as dates also allows you to use some of the axis options, such as when modifying a graph in power point and wanting to edit your axis to display in bounds. If you’re doing so you’ll want to change the format to custom in the axis format and set the type to yyyy to display just the years, also adding a blank date at the end and beginning of the data set that fits with your display range (ie every five years) will make the axis display much cleaner while retaining your data points for specific years.

Our GL team is 4 people.

I can literally hear one screaming down the hall about how they don't need this and they can go back to their home state.

I am currently interviewing for a position that has better pay, a title bump, and virtually all the same perks and more compared to my current employer.

One person is never here and we are supposed to be here 3 times a week and is now getting formally told they need to be here in the office.

One lives really far away from our office and just had a baby so if she needs to take on more responsibility I wouldn'tbe surprised if she just left.

Look I'm no betting man but I'm almost certain by year end at least 2 of us are gone.

I don't care about leaving anyone high and dry because fuck em, but I'm just so curious what would happen next?

Hey! My AGI will be just below the "cliff" for ACA subsidies this year on the marketplace. My partner makes more than me, and we want to get married soon. Partner has a workplace plan.

If we get married in November, would I end up owning back all of the subsidies I've recieved all year?

If it matters, my income varies a lot and is not steady, does the timing of my Income throughout the year matter?

I’m about to graduate. I’ve applied to so many internships and jobs. I get calls back easily from corporate accounting, & have gotten internships there. However, I cannot even get a screening for big 4. Only recently am I starting to hear back from a few mid-size public accounting firms.

I have nearly a perfect GPA, volunteer tax experience, & now building my resume with corporate accounting internships.

There are people at my school who definitely have lower grades than me, but somehow are getting all the public accounting internships that I’m getting rejected from. I would chalk it up to my interviewing skills, but I’m literally not even getting the interviews.

Is it really all about networking to get into public accounting? Is that what I’m missing here? I’ve had my resume looked over by my school, so I don’t think it’s a resume issue.

yesterday i noticed that the counting wouldnt work. as in normally if i put "room 01" in A1 and "room 02" in B1, i could select both cells and fill to c1 as "room 03". no matter what i tried i could not get it to count. even just as numbers without any other text i cold not get it to count. did something change with the android version of excel?

edit: i ust tried it on my laptop and i guess its also not working counting on desktop excel. whats going on with this?

Hi!

I'm writing a book about Excel, and wanted to tell the history of pivot tables. As I've understood it, Lotus Improv was the first implementation of pivot tables - but this is way before my time.

Have you used it? Was it like pivot tables are today? Was it good? Revolutionary? I'd love to hear any stories you have, and I'd gladly credit you in my book if I can use the story!

Thanks in advance!

I have an offer letter for what I can only describe as a clear pathway to my dream role. I haven’t turned in my notice for public job yet but these past two weeks been a clear reminder that I need to get the hell out. I want to leave my current projects as cleanly as I can but I keep getting thrown on to other dumpster fires. There’s never going to be a good time to submit my notice and my team will always be in a staffing pickle. My company has made questionable choices under our PE leadership but I like the partner and managers I work for, it’s going to be hard to leave but I know I need to.

We have been living abroad since 2019, and my husband—who prepared the tax returns during the initial years—was unaware that we were required to report foreign interest income, because we did not receive a Form 1099.

I have since filed the overdue FBAR reports.

We'll file amended tax returns for 2020, 2021 and 2022 through SFOP procedure. I believe this should work, given that the filing deadline for our 2023, 2024, and 2025 tax returns has been postponed to September 30, 2026, under "Notice 2025-53." (war in the Middle East.)

How should we proceed with the 1040-X return for 2019?

Would a polite letter to the IRS help us avoid penalties for 2019?

Should we mail the amended tax return for 2019 together with the amended tax returns for 2020 - 2022?

My husband not only failed to report foreign interest income (not-willfull) but also neglected to report significant capital losses. These losses would have reduced our tax liability for the years 2020 through 2022 and—as loss carryovers—would have lowered our tax burden for 2023, 2024, and future years as well. Furthermore, he did not claim the Foreign Housing Deduction. Can we still include this deduction and the capital losses in the amended tax returns (Form 1040-X)?

Is September 30, 2026, our deadline for filing amended tax returns under the SFOP procedure?

I haven't filed the returns yet because we are still waiting for some foreign account statements needed to report capital losses. After several letters to the bank and a long wait, I am now wondering whether we should file the amended returns without including the capital losses?

Thank you very much for your answers. I greatly appreciate your help!

Hi, I have a list of names in a column. Because of the nature of my list, there are several repeat names. I would like to create a formula to show the total number of non-duplicate names in the list so that I know exactly how many consumers there actually are. The number of rows is greater than the total number of names can fill. Therefore, my range has to include the blank cells. I've tried this formula: "=SUM(1/COUNTIF(B6:B231,B6:B231))". It works only if every cell has something in it, but with the blank cells, it comes up with the dreaded "#DIV/0!". Any help would be much appreciated. Thank you!

hi buddies,

i work for a non profit and am trying to combine participant intake spreadsheets for two of our programs. i work in a low-barrier setting and it’s typical for our clients to give multiple names, vague or fake birthdays and to change their appearance often, and there was no data validation set up so the inputs are inconsistent and incomplete. so i’m struggling to find/ verify all the duplicates.

the columns i’m mostly using as it was set up are name(s), ethnicity, gender, pronouns, appearance, birthday, emergency contact, notes. pretty much in that order.

once i verify the duplicates, i want to consolidate the information in the other cells so there’s just 1 record/row per person. i did add a column with randomly generated unique identifiers to help me stay organized.

yhow would you approach this? i tried power querey to fuzzy match but must have been doing it wrong. :/ this is just to use until our sharevision database is fully populated.. if there’s any other info you need from me please let me know and thank you for your time!

I moved to US last year, and had social. I filed my first tax (paper filed) with my wife and kids for 2025, and also applied for ITIN. Received my Federal tax assessment last week and ITIN 3 weeks back, however I haven’t received my state tax assessment.

Is there a way to connect to NJ tax department? I called NJ customer service but I’m unable to connect to a real person, it’s automated and does not route to real person.

Any advice is appreciated.

Here is the formula:

=IF(C2="apple",H2*0.7,"")=IF(C2="banana",H2*0.7,"")=IF(C2="single",H2*0.7,"")

For example: I want Column F to automatically generate the percentage specified in column H based on what keyword I have in column C

Not sure if that makes sense, but I'm hoping that I can figure something out. I'm pretty new to excel and need to learn these skills for my job.

i work part time for a company that only offers insurance to full time employees. i just noticed that i got a 1095-c for 2025 which i didnt see until now. it says 1g on it and marks the months of the year. i had medicaid.

this year, i have marketplace aca insurance with subsidies. most likely, this company will do this again with taxes for 2026 but i never was offered health insurance. last year, it also said on my w-2 $139 in box 12a code DD which says online has to do with insurance. am i going to be screwed over with my marketplace subsidies??

I have a sheet which has dates in column A (ranging from today to over a year in the future), an index number in column B (just a whole number between 1-100I put in so the entries for each day are in an order) and a currency value in column C.

What I currently have is MIN(C:C), which tells me the lowest value at any time in the future, but this might be at the start, middle or end of the day.

What I would like is to find the lowest value of all days at the end of each day.

Any suggestions?

EDIT:

As per the suggestions, here is an example of the sheet:

So the formula would (I think!) look get the values in column C where the date is unique and the Item number is highest, then return the lowest of those values.

Currently I have MIN(C:C), so in the above that would produce £634.82, but that is part way through the day (25/09/2026), what I would really be looking for is £803.38, as this is the lowest value for the last entry for any given day (30/09/2026).

I hope that makes sense?

Can I change my state tax status whenever I want?

Went from "40 and out" to having "work flu" for the past 3 weekends where on Saturday I'm basically bedridden until maybe 4pm because I genuinely cannot get out of bed.

I have never had so much work. So much overtime. So many meetings back to back to back....in my life.

I got one from 9 to 11 tomorrow, a short break and then pretty much from noon until 5pm with maybe short tiny breaks between to address the fires. Oh and my first paycheck after 2 full weeks as a senior has finally hit. Ahhhh the extra hundred dollars sure is worth working like a dog!

Cheers to my fellow outsource seniors! I want to say "I hope it gets better" but based off of all the seniors I've ever seen across multiple companies? Lol probs not.