The Deuce

The Deuce
[ The Deuce ]

Excel question

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:10:28

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

This time of year that’s an Excel Lent question*

Posted by Franklin <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Franklin' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:43:24, in reply to "Excel question "

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

*amused chuckle* *

Posted by IlliniRunner <iframe src='https://mb.boardhost.com/TheDeuce/info/user=IlliniRunner' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 20:02:40, in reply to "This time of year that’s an Excel Lent question*"

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

rimshot

Posted by osklister <iframe src='https://mb.boardhost.com/TheDeuce/info/user=osklister' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 17:03:17, in reply to "This time of year that’s an Excel Lent question*"

Lol*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 14:31:05, in reply to "This time of year that’s an Excel Lent question*"

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

go.gif *

Posted by doubledown <iframe src='https://mb.boardhost.com/TheDeuce/info/user=doubledown' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:44:05, in reply to "This time of year that’s an Excel Lent question*"

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

=COUNTIF(A2:A10, "<"&B1)

Posted by Chilango <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Chilango' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:18:22, in reply to "Excel question "

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

This is actually a really good use case for ChatGPT

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:13:50, in reply to "Excel question "

Yes. In Excel or Google Sheets, you can count how many dates in a row occur before a specified date using the COUNTIF function.

Example

Assume:

Columns A–D contain the dates.

You want to count how many are before June 1, 2026.

Column E will contain the formula.

Put this in E2:

=COUNTIF(A2:D2,"<"&DATE(2026,6,1))

How it works

A2:D2 → the four date cells in that row.

"<"&DATE(2026,6,1) → counts values earlier than June 1, 2026.

The result will be 0–4, depending on how many dates meet the condition.

If the comparison date is in a cell

If the cutoff date is in F1, use:

=COUNTIF(A2:D2,"<"&$F$1)

This lets you change the date once in F1 and have all rows update automatically.

If some cells might be blank

COUNTIF already ignores blanks, so the formula still works correctly.

✅ If you'd like, tell me:

Excel or Google Sheets

whether the cutoff date changes per row or is one fixed date

…and I can give you the best formula for your exact layout.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

BTW, this worked but I messed up the formula initially and ended up googling it anyway*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:51:45, in reply to "This is actually a really good use case for ChatGPT"

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

I don't use AI for work*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:16:36, in reply to "This is actually a really good use case for ChatGPT"

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

Is it because it's not allowed? Or because you're an old now? *

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

To ask for an Excel formula?

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:18:22, in reply to "I don't use AI for work*"

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

There are lots of reasons that people don't even have access

Posted by Chilango <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Chilango' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:19:03, in reply to "To ask for an Excel formula?"

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

I despise AI, and think it's mostly evil

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:20:58, in reply to "There are lots of reasons that people don't even have access"

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

It's that computers are blocked from using it/ accessing it for valid reasons

It's binary. If someone has access to certain types of information they don't have access to AI. This is just like social media access which is completely blocked for people because it's not appropriate when you have access to certain types of information. It mitigates both intentional and unintentional misuse or dissemination of information. In Taz's case I imagine it's HIPAA and PII related.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Buckle up, buttercup. If you hate this stuff, this ride's about to get wild. *

Posted by doubledown <iframe src='https://mb.boardhost.com/TheDeuce/info/user=doubledown' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:24:53, in reply to "I despise AI, and think it's mostly evil"

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

I do Google searches and those searches employ AI

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:23:20, in reply to "I despise AI, and think it's mostly evil"

I'm not allowed to use open source AI for work due to confidentiality issues and my job definitely isn't paying for us to use AI.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

A simple google query would answer this then*

Previous Message

I'm not allowed to use open source AI for work due to confidentiality issues and my job definitely isn't paying for us to use AI.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

I could have done that, yes. I find that the people here explain things to me better than searches*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:35:15, in reply to "A simple google query would answer this then*"

Previous Message

I'm not allowed to use open source AI for work due to confidentiality issues and my job definitely isn't paying for us to use AI.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

Sorry, taz, but the people have spoken.

Posted by Sammich <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sammich' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:37:42, in reply to "I could have done that, yes. I find that the people here explain things to me better than searches*"

Crowdsourcing requires data theft and runaway resource hoarding now.

I want to break it up
I want to smash it up
I want to #### it up
I want to watch it come down

Yeah but then I wouldn't have gotten a pun response that made me laugh (see Franklin's post above)*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 14:31:44, in reply to "Sorry, taz, but the people have spoken."

Previous Message

Crowdsourcing requires data theft and runaway resource hoarding now.

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

An interview asked me about my PowerPoint skills

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 14:42:51, in reply to "Yeah but then I wouldn't have gotten a pun response that made me laugh (see Franklin's post above)*"

and told him that I Excel at it. He said, is that a Microsoft Office joke, and I said "Word".

Previous Message

Crowdsourcing requires data theft and runaway resource hoarding now.

Your humor

Posted by bjl63 <iframe src='https://mb.boardhost.com/TheDeuce/info/user=bjl63' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 15:35:13, in reply to "An interview asked me about my PowerPoint skills"

is too OneNote

I'll try to Access wider range*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 17:28:59, in reply to "Your humor"

Previous Message

is too OneNote

Then you can have a more positive Outlook on it*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 18:22:44, in reply to "I'll try to Access wider range*"

Previous Message

is too OneNote

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

My OneDrive is to be funnier*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 19:42:22, in reply to "Then you can have a more positive Outlook on it*"

Previous Message

is too OneNote

It would give you a bit of an Edge*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:12:59, in reply to "My OneDrive is to be funnier*"

Previous Message

is too OneNote

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

I want to be a Teams Player*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:33:14, in reply to "It would give you a bit of an Edge*"

Previous Message

is too OneNote

You *really*wanna be a teams player*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:50:08, in reply to "I want to be a Teams Player*"

Previous Message

is too OneNote

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

Boardhost has sucked for a few months now*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:53:31, in reply to "You *really*wanna be a teams player*"

Previous Message

is too OneNote

I want to be a Teams Player*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:33:03, in reply to "It would give you a bit of an Edge*"

Previous Message

is too OneNote

I want to be a Teams Player*

Posted by Sounder <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Sounder' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 21:32:53, in reply to "It would give you a bit of an Edge*"

Previous Message

is too OneNote

It’s called Socialism. *

Posted by doubledown <iframe src='https://mb.boardhost.com/TheDeuce/info/user=doubledown' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:39:06, in reply to "Sorry, taz, but the people have spoken."

Previous Message

Crowdsourcing requires data theft and runaway resource hoarding now.

it's teaching you to fish*

Posted by assassin <iframe src='https://mb.boardhost.com/TheDeuce/info/user=assassin' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:37:37, in reply to "I could have done that, yes. I find that the people here explain things to me better than searches*"

Previous Message

I'm not allowed to use open source AI for work due to confidentiality issues and my job definitely isn't paying for us to use AI.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Brandon Schrock of Laredo, Texas, told the federal government that his employer was “poop,” and his occupation was “pooper.”

But that also uses AI now. How is that better*

Posted by gvibes <iframe src='https://mb.boardhost.com/TheDeuce/info/user=gvibes' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:29:20, in reply to "A simple google query would answer this then*"

Previous Message

I'm not allowed to use open source AI for work due to confidentiality issues and my job definitely isn't paying for us to use AI.

Previous Message

but this feels like a pretty basic use case. In fact, it's one of the few ways that I use AI.

Previous Message

Nor shouldn't

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

That's what y'all are for*

Posted by Taz <iframe src='https://mb.boardhost.com/TheDeuce/info/user=Taz' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:18:56, in reply to "To ask for an Excel formula?"

Previous Message

You should be, it's there to help you, and I fucking hate AI.

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Sometimes you just need to yeet a bobcat *

Being an Illini fan is a goddamn curse.*

ask copilot*

Posted by John Coctostan <iframe src='https://mb.boardhost.com/TheDeuce/info/user=John+Coctostan' width='330' height='300' border=0 style='border:none;'> on March 9, 2026, 13:12:25, in reply to "Excel question "

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

Yup. *

Previous Message

I have a spreadsheet with 4 columns of dates. Is there a formula I can put into a fifth column that will tell me how many of the dates in each row are before a certain date?

« Back to index

225

[ The Deuce ]