Custom Date Format using META Instruction

[pizzaboy]

If a date is over a year old, I would like the cell to show "yyyy", otherwise "mm/dd".


I've tried:
<date(year(today())-1,month(today()),day(today()))]yyyy;mm dd
<date(year(today())-1,month(today()),day(today()))]yyyy;mm dd
<date(year(today())-1,month(today()),day(today()))]yyyy;mm dd

[< DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))]yyyy;mm/dd
<date(year(today())-1,month(today()),day(today()))]yyyy;mm dd
<date(year(today())-1,month(today()),day(today()))]yyyy;mm dd"

but Excel reverted the instruction back to [<0].




I then tried:

[<42931]yyyy;mm/dd

but it always return the "mm/dd" format. 42931 is DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())) converted to a number.




Is this even achievable?


Any help would be greatly appreciated.


Thanks.</date(year(today())-1,month(today()),day(today()))]yyyy;mm></date(year(today())-1,month(today()),day(today()))]yyyy;mm></date(year(today())-1,month(today()),day(today()))]yyyy;mm></date(year(today())-1,month(today()),day(today()))]yyyy;mm></date(year(today())-1,month(today()),day(today()))]yyyy;mm>

 

[Fluff]

Another option is click on Go Advanced & select HTML off
=C2<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))