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
Should it be
=SE(E(MESE(A3)>=5;MESE(A3)<=9);600;0)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
=SE(E(MES(A3)>=5;MES(A3)<=9);600;0)
it works like a charm
many thanks
Posting Permissions
Reply With Quote
