You need to sign in to do that
Don't have an account?
Frances 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?
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 Vakati
Looks like copied same formula twice . This is the correct one i guess
Frances 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 Vakati
Is its solved now?
Frances 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.