+ Start a Discussion
Frances AllenFrances Allen 

Incorrect Use of IF statement Question

Hello All, 

I believe that this formula is incorrect in that we cannot use an if statement this way. If there are any pros on the board that quickly double-check my knowledge.
The purpose of this field is to determine current school year according to fiscal year which is after July. 

IF (MONTH(TODAY())>=7, YEAR(TODAY())+1,
IF (MONTH(TODAY())<7, YEAR(TODAY()),0))
IF (MONTH(TODAY())>=7, YEAR(TODAY())+1,
IF (MONTH(TODAY())<7, YEAR(TODAY()),0))

If today’s month is greater or equal to July add one more year to the year otherwise if false  
And today’s month is is less July, todays year, otherwise 0
 
Wouldn’t it be just YEAR(TODAY()) with no comma and zero following?



 
Raj VakatiRaj Vakati
Looks like copied same formula twice  . This is the correct one i guess 
 
IF (MONTH(TODAY())>=7, YEAR(TODAY())+1,
IF (MONTH(TODAY())<7, YEAR(TODAY()),0))

 
Frances AllenFrances Allen
You're correct, sorry the long reply - this is copied twice. I think this code is referring to July because July 1st is the beginning of the company's fiscal year.
Raj VakatiRaj Vakati
Is its solved now?
Frances AllenFrances Allen
Is my assumption correct on how this formula is set up - if it is before July add a year to today's date (this is a field called 'current year') otherwise do not add anything, however there is a 0 with no plus sign beofre it.