#Date Expected Error

Darla Brown

Hi,

I have 2 sheets - 1 is for active projects and the other is for completed. They both have the same columns. One the active sheet my month helper formula =IFERROR(MONTH([Date Update Request]@row), 0) works perfectly. On the completed sheet, it returns a #DATE EXPECTED error. The columns are all date columns.

Any ideas?

Andrée Starå

Hi @Darla Brown

I hope you're well and safe!

Can you share some screenshots and paste the formulas? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!