Posts Tagged help
Date formula help
I have a column of dates (column G) in date format and I’d like another column to display
the fiscal or academic year for that date. I’d basically like a formula that will look at the date in column G and tell me if it is from 2001-02 or 2002-03, etc using July 1-June 30 as the fiscal or academic year. How do I do this?
Formula :
=IF(G3>DATEVALUE(“06/30/” & YEAR(G3)),”Academic Year ” & YEAR(G3) & ” – ” &
YEAR(G3)+1,”Academic Year ” & YEAR(G3)-1 & ” – ” & YEAR(G3))
Add comment November 9, 2007