Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2013-03-28 04:20:55 +0200

ROSt52 gravatar image

@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 for the =month(xxx) is not correct.

I would use

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

My formula 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.)

@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 for the of =month(xxx) is not correct.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 formula formulas would result in 70 for every day in march 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.)

@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?