Formula with IF, TODAY and MAX not working.

[reberryjr]

I'm not sure why this formula isn't working. If AZ2 = "", then I want to return the value of 0. If it isn't null, I want to get the number of days between Today and the max date in column AZ.

=IF(AZ2="",0,TODAY()-(MAX(Financials!AZ:AZ)))

When I enter the formula on the Financials sheet, it works fine (obviously without the sheet reference).

Thoughts?

 

[dreid1011]

How is it not working?

 

[reberryjr]

It's returning a value of 0, but AZ2 is not = "", so it should move to the false portion of the formula.

 

[dreid1011]

What is in AZ2?

 

[Aladin Akyurek]

This AZ2 is a cell of Financials!AZ:AZ?

And in which sheet are you running your formula?

 

[reberryjr]

AZ2 contains a date, and the formula is entered in a sheet called Summaries.

 

[Aladin Akyurek]

AZ2 contains a date, and the formula is entered in a sheet called Summaries.

Entered in Summaries, say in A4, the formula:

=IF(AZ2="",0,TODAY()-MAX(Financials!AZ:AZ))

would give a 0 if AZ2 is empty or a figure that would result from substracting MAX of the AZ column from Today's date.

 

[reberryjr]

I tried that, but it's still returning a value of 0, despite there being a date in AZ2

 

[dreid1011]

And that is AZ2 on the 'Summaries' sheet that has a date in it, correct?

 

[Fazza]

Is the workbook on auto-calculate?