Why Won't This AI-Generated Formula Work?

Ann.Cracovaner

I used the AI formula generator tool to create a formula to count the cells in a referenced column in another sheet if the due date is in the next 5 days. This is what was created, but I keep getting the #INCORRECT ARGUMENT SET message. I can't seem to figure out what needs to be adjusted. Anyone have any ideas?

=COUNTIFS({MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3}, <= TODAY() + 5, {MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3}, >= TODAY())

Darla Brown

Hi,

Try switching it around:

=COUNTIFS({MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3},>= TODAY(), {MAR_DSS_CTMS_LG_SEC FA Resource Assignment Range 3},<= TODAY() + 5)

Ann.Cracovaner

Thanks for the idea Darla! I tried that and it's now giving me the #INVALIDOPERATION error message. Any other suggestions on how to fix this?

Darla Brown

So Sorry! I was out of the office last week. Are your dates in Date Columns?

Ann.Cracovaner

@Darla Brown , yes they are. I think I was able to get this working. Here's what I have as the formula now:

=COUNTIF({Ali Projected Completion Date}, AND(ISDATE(@cell ), @cell <= TODAY() + 5, @cell >= TODAY()))

Darla Brown

If it's working, don't change a thing! lol Sorry I wasn't able to help earlier.

Ann.Cracovaner

not a problem! I'll reach out if it becomes uncooperative.