Why is my NETDAYS function returning a result of more than 36,000

Sonja

I'm trying to find the difference between today and a prior date, in this image it's the Helper Date column. I've confirmed this is an actual date format with the ISDATE function and it's working as expected in some other formulas. In this formula the result for the row displayed should be 18 days but I'm getting a result of 36,544. I've tried using today both from a 2nd column and within the formula such as shown here. Ideas?

Screenshot 2022-09-13.png

Andrée Starå

Hi @Sonja

I hope you're well and safe!

Try changing the date format to ensure it's the correct year.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!

Andrée Starå

Hi @Sonja

I hope you're well and safe!

Try changing the date format to ensure it's the correct year.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

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!

Sonja

That did resolve my issue, thank you! The first date was using 1922 rather than 2022. Resolved. :)

Andrée Starå

@Sonja

Excellent!

Happy to help!

✅Remember! 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!