If Statement

P

Pam

I am working on a spreadsheet with an IF Statement. I
have a data row with weekly increments, ie: jun-14,jun-
21,jun-28,jul-5
I want to perform the IF true every time the month changes
example: jun to jul but not when the month goes from jul-
5 to jul-12. Currently the IF statement is not
recognizing the month. Thanks
 
F

Frank Kabel

Hi
maybe something like
=IF(MONTH(A1)<>MONTH(A2),"month changed in A2","no change")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top