Max Date using recursive function

**karthick_s09** · 09-29-2016, 02:37 AM

Hi All,

Can someone help me with the formula for below logic please:

Description: Have multiple rows with the same desk name but different dates. I would like to have a formula which returns the max date with in the given date range.

I tried using the below formula and everything is returning no. Can someone assist me to fix it pls?

=if(deskname=deskname,if(and(date>=25-Apr-2016, date <=01-May-2016)),max(date),"no"). I tried using it as array as well but no luck.

example below:

Desk 1 01-May-2016

Desk 2 29-Apr-2016

Desk 1 28-Apr-2016

Thanks in Advance.

Karthick

**Glenn Kennedy** · 09-29-2016, 02:47 AM

Try this, with start date in G1 and end date in G2. An array entered formula:

=MAX(IF($A$1:$A$3="desk 1",IF($B$1:$B$3>=$G$1,IF($B$1:$B$3<=$G$2,$B$1:$B$3))))

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...