cpampas
07-14-2019, 11:59 PM
Hello,
Can somebody help with an expression to add a value into a cell based on the month part of a date of another cell. I have tried so far with no result :
=SE(and(MONTH(A3)>=5;MONTH(A3)<=9);600; 0)
meaning that if the month is between 5 and 9, the cell values equals 600, otherwise it will be 0
thanks a lot
Can somebody help with an expression to add a value into a cell based on the month part of a date of another cell. I have tried so far with no result :
=SE(and(MONTH(A3)>=5;MONTH(A3)<=9);600; 0)
meaning that if the month is between 5 and 9, the cell values equals 600, otherwise it will be 0
thanks a lot