If/Then Date Range

[pjandshelly]

Good morning Group,

I have a date column that may be causing the problem. Output for Date Column: AUG 18,2017@15:48:01. I am looking for an If/Then Statement that states if Date Range is between "Oct 01,2016@0000" and "Sep 30,2017@2359", then "FY17", if date range is greater than "Oct 01,2017@0000" then "FY18".

Any help is greatly appreciate.

 

[Kamolga]

With A1 being the date you look for:

=IF(AND(A1>=DATE(2016,10,1),A1<DATE(2017,10,1)),FY17,IF(A1>=DATE(2017,10,1),FY18,"Date before 1/10/2016"))

 

[pjandshelly]

I get an error, When the first character is an equal or minus sign...

=IF(AND(c2>=DATE(2016,10,1),c2<<date(2017,10,1)),fy17,if(a1>=DATE(2017,09,30),FY18,FY17))

I get the same error with your formula.
</date(2017,10,1)),fy17,if(a1>

 

[Kamolga]

That is because it is not a date anymore. If you put =1/1/12018, it becomes a division and negative date is impossible.