Comma Displayed in Calculate Result 1

[richardlpalmer]

I have a caluclated column used to calculate a fiscal year.

[tab][small]=IF(NextReleaseDate=DATE(2009,7,1),YEAR(NextReleaseDate),IF(MONTH(NextReleaseDate)<7,YEAR(NextReleaseDate),(YEAR(NextReleaseDate)+1)))[/small]

It gives a correct year, but the displayed result is less than desireable due to the addition of a comma in the number.

I've tried having the result returned as single line text but it still returns the number with a comma in the thousands position. Trying to use the Date and Time option does not work as it attempts to return a full calendar date instead of just the year.

If I could get the comma to not display that would be ideal. Any help is appreciated.

 

[niceguymattx]

Try wrapping your function with the TEXT function:

=TEXT(IF(NextReleaseDate=DATE(2009,7,1),YEAR(NextReleaseDate),IF(MONTH(NextReleaseDate)<7,YEAR(NextReleaseDate),(YEAR(NextReleaseDate)+1))),"@")

 

[richardlpalmer]

Thanks niceguy, but when I attempted this it made the outcome negative:

 

[richardlpalmer]

Okay, I used a slightly different version of what you provided and it worked perfectly.

=TEXT(IF(NextReleaseDate=DATE(2009,7,1),YEAR(NextReleaseDate),IF(MONTH(NextReleaseDate)<7,YEAR(NextReleaseDate),(YEAR(NextReleaseDate)+1))),"0")

Thanks for the help!