First time here? Check out the FAQ!

1 | initial version |

@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.)

2 | No.2 Revision |

@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.)

3 | No.3 Revision |

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

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.