@mahfiaz - I looked at the very interesting formula you proposed but what is the result of your formula?

I am getting an error message and feel the the argument of =month(xxx) is the cause.

I would use

=IF(MONTH(DATE(2013,3,30))=MONTH(NOW()),1,0)*70

or more simplified

=IF(3=MONTH(NOW()),1,0)*70

where the first "3" represents the month.

My formulas would result in 70 for every day in March in every year.

However, I also would like to understand your formula because there are often several ways. (Actually your formula helped me to develop mine; thus thanks for your hint.)

(I am using comma as a separator.)

@Huskey - I am aware that this is not yet the answer to your question, but can use the sketches of @mahfiaz and me to develop the formula you needed?

What's in C7 on the 5th April 2013?

5TH April 0 Dollars; 6th April 70 Dollars; 6 May 140 Dollars; 6 June 210 Dollars ... 6 February 2014 840 Dollars.