Function to Display a number when today's date is between 2 dates and the status is something

Platform discussions
1

Hello,
I am trying to set up If+and formula to display number from number’s column when todays date is between 2 date columns (Start and End date columns), and the status is NOT “Invoiced”. I have putted together the following formula, but I am getting an error.
Thank you in advance

IF(AND(TODAY()>={Start Date},TODAY()<={End Date}),{Status}!=“Invoiced”),{Number Column},“0”)

2

Hi @Hayk,

Try:

IF(AND(FORMAT_DATE(TODAY(),"YYYYMMDD")=FORMAT_DATE({Start Date},"YYYYMMDD"),{Status}<>"Invoiced"),{Number Column},"0")

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.