Newbie question - Display last 2 digits of Year in string

[shanefowlkes]

Sorry if this is too basic but what's the syntax in Excel for appending a date calculation to a string. For example, I want to display something like:

"Application for Fiscal Year FY03" The "03" is the last 2 digits of 2003 - the current year. So I imagine I'll need something like:

="Application for Fiscal Year FY" & Format(Year(Date()), YY)

..in the cell. Something along those lines anyways....

Thanks

 

[kskinne]

Re: Newbie question - Display last 2 digits of Year in strin

use this for your formula:

="Application for Fiscal Year FY "&RIGHT(YEAR(TODAY()),2)


hth
kevin

 

[shanefowlkes]

Re: Newbie question - Display last 2 digits of Year in strin

use this for your formula:

="Application for Fiscal Year FY "&RIGHT(YEAR(TODAY()),2)


hth
kevin

THANKS!

 

[Joe4]

Re: Newbie question - Display last 2 digits of Year in strin

This works for me:

="Application for Fiscal Year FY" & TEXT(NOW(), "YY")

 

[Mark W.]

Re: Newbie question - Display last 2 digits of Year in strin

="Application for Fiscal Year FY" & TEXT(TODAY(),"yy")