Jetreports/Excel formula

Hi,

I am modifying a JetReports. May I ask a suggestion? How do I manage my multiplier that depends on the AsOfDate?

For example:

  1. As of date: 01/02/2013
    Value: 500

Solution := 500 * 1 = 500
when I run the report, the value will multiply depends on the As Of Date(January)

  1. As of date: 02/01/2013
    Value: 500

Solution := 500 * 2 = 1000
when I run the report, the value will multiply depends on the As Of Date(February)

  1. As of date: 03/02/2013
    Value: 500

Solution := 500 * 3 = 500

when I run the report, the value will multiply depends on the As Of Date(March)

I got the solution!

=MONTH(C4)*500
Where C4 is where your As Of Date is.

The Month() formula of Excel will only gets the number of the month depending on the given date.
Try it out!

Credits to Bert!