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


Archives

Recent Comments

rshewade on Text Split with Excel Formula …
Tweety22 on Text Split with Excel Formula …
rotem on Excel Function – LA…
rshewade on Text Split with Excel Formula …
arindam on Text Split with Excel Formula …

Blog Stats

Tags

Advanced Conditional Formatting Excel excel functions Formula Functions help Large MS EXCEL MSEXCEL Named Ranges pivot table PivotTable ranges rare Shortcut Keys Table Formatting text text formula text separate text split tips Top10 tricks Useful Zebra Stripes

Recent Posts

Blogroll