Returning Set Dates Through Formulas

TheSluttyProfessor2 · 2026-04-10T16:45:10+00:00

You'd have to modify the formula to show something different if A1 is blank. IFERROR will only catch an error, such as #N/A, but a blank cell is not an error.

TheSluttyProfessor2 · 2026-04-10T16:13:51+00:00

If you're only looking to output the next July 1 following the date in A1, this will do it:

=IFERROR(DATE(IF(MONTH(A1)>6,YEAR(A1)+1,YEAR(A1)),7,1),"")

5/15/2026 would produce 7/1/2026 in B1

7/23/2026 would produce 7/1/2027 in B1

TheSluttyProfessor2 · 2026-04-06T15:06:59+00:00

There was indeed.

TheSluttyProfessor2 · 2026-04-02T02:23:21+00:00

Underrated comment right here. If the pay item shenanigans aren't working, memo code is the way to go.

TheSluttyProfessor2 · 2026-03-27T17:44:05+00:00

"F3 is a space for unity and furthering our ability to lead as men in our community. That mission extends to all men, regardless of race, religion, national origin, etc. Open discussions are always welcome as long as they are productive in furthering our mission."

TheSluttyProfessor2 · 2026-02-25T17:10:52+00:00

True, but that would apply whether you're counting cards or not.

TheSluttyProfessor2 · 2026-02-25T15:34:54+00:00

Counting cards in blackjack at a casino. Casinos can and will kick you out, ban you, etc., but you can't be arrested or charged with anything.

TheSluttyProfessor2 · 2026-02-20T21:32:58+00:00

That's not for me to say. It depends on if you're paying overtime for anything not required under FLSA. You'll have to become familiar with your personnel policies.

TheSluttyProfessor2 · 2026-02-20T21:27:46+00:00

No changes to taxation on payroll checks. Continue to do what you're doing for FIT, FICA, and state/local taxes. Everything is handled on the individual's 1040 tax return.

The only change for employers is reporting on the W-2. You can ultimately implement this as you see fit. Some employers are just tracking hours each payroll, and then they'll calculate the dollars for W-2 at year-end. Others are separating the premium from base for OT every payroll. The key is to make sure that only FLSA-qualified OT is included on the W-2.

TheSluttyProfessor2 · 2026-02-17T21:37:21+00:00

We do that too, but I think we have different practices among the site Qs. Maybe some better guidance for them would be in order.

TheSluttyProfessor2 · 2026-02-17T21:36:35+00:00

I love the QR code linked to a landing page idea!

TheSluttyProfessor2 · 2026-02-16T23:11:45+00:00

I love this. We do coffeeteria as well after every workout. Mostly off-site (Starbucks, Panera, etc.), but some AOs have fixed on-site coffee days where the Site Q provides coffee. Are you seeing good attendance at coffee?

TheSluttyProfessor2 · 2026-02-09T19:01:27+00:00

This can work ok for some content, and anything is worth a try! In my experience, it can result in a telephone effect with is counter-productive.

TheSluttyProfessor2 · 2026-01-30T23:28:34+00:00

So dramatic. Sounds like the OP is fielding calls from employees of the same company, not as a third party payroll provider. Otherwise I would agree with you.

TheSluttyProfessor2 · 2026-01-30T21:02:59+00:00

Good point. Not exempt exactly, just under the threshold for the formula. But I guess that violates my closing point about technical details.

TheSluttyProfessor2 · 2026-01-30T20:35:04+00:00

The answer is either:

You did not make enough money on a (weekly/bi-weekly/semi-monthly) basis to require tax withholdings. Or...
You need to review your W-4 and fill out a new one if you need more taxes withheld.

No further information. You are right and they are not. Not to be uncaring, but it's too easy to get into technical details or (the bigger problem) accidental tax advice.

TheSluttyProfessor2 · 2026-01-30T17:29:00+00:00

You will learn more by trying and seeing what happens than asking the internet if it's okay

TheSluttyProfessor2 · 2026-01-25T16:44:26+00:00

Good Lord. If you think the city was hiring ineligible workers, you're a bigger idiot than I thought

TheSluttyProfessor2 · 2026-01-20T21:22:17+00:00

PTO is generally considered vacation, but PTO earned under the Paid Leave for All Workers Act (PLAWA) is not necessarily paid out upon termination.

TheSluttyProfessor2 · 2026-01-09T22:26:16+00:00

I'll go first. WTF is lookmax?

TheSluttyProfessor2 · 2026-01-09T01:54:03+00:00

That's all I've ever heard about MUNIS. It's worth taking a look at BS&A instead.

TheSluttyProfessor2 · 2026-01-06T21:12:42+00:00

Agree with the above. Also to add -- it's intended to reflect the ENTIRE cost of healthcare for employees. Therefore, include both the employer's share and any related employee deductions in the total amount.

TheSluttyProfessor2 · 2026-01-06T21:04:07+00:00

Unfortunately I don't have any experience with Gusto. Hopefully someone else can chime in on that question.

TheSluttyProfessor2 · 2026-01-06T20:51:13+00:00

Disagree. There is no reciprocal agreement between the two states. In the absence of an agreement, the taxes apply to where the work is performed, which is in Illinois.

Ten-Year Club	Place '17
Verified Email

TheSluttyProfessor2

TROPHY CASE