IF formula with dates

Richard Stanton

Hi

Can anyone assist with why this formula doesn't work? Ideally I would like to return a text result of "FY18" if the dates are in the range 01/07/17 to 30/6/18.

Thanks in advance.

Richaerd

Andrew Duval

Hello Richaerd,

I came up with this when testing in my sheet:

=IF(AND([Click date cell] > DATE(2017, 7, 1), [Click date cell] < DATE(2018, 6, 30)), "FY18")

This formula should be pasted in whichever cell you want "FY18" to be displayed. 

 

Richard Stanton

Thanks Andrew that worked a treat. By the way I misspelled my own name. It's Richard. IPhone typo!

Thanks again for the help. 

Richard