Barchart and dates

[silviacico]

Hello,

I hope some of you experts may help me 🙂

I have a barchart with dimension: 

=if(month([Date of Event Reference])<month(Today()),
   [Date of Event Reference Year Month],
                 if(week([Date of Event Reference])<week(Today()),
                 WeekName([Date of Event Reference]),
                                          [Date of Event Reference]))

and it shows previous months, previous weeks of the current month and the days of the current week.

I need to color the bars like this:

if(week([Date of Event Reference]) =week(today()), green(),
          if(month([Date of Event Reference]) = month(Today()) and week([Date of Event Reference]) <> week(today()), blue(),
                        if(num(month([Date of Event Reference])) < num(month(Today())), yellow())))

but it seems to work only the first statement: 

if(week([Date of Event Reference]) =week(today()), green()

Thank you very much, any advice and suggestions will be very appreciated