Hello,
I'm trying to create a report where a certain value should be updated if it is within a certain month. When the month has passed and transferred into the next month, the value should remain as it last was before the monthly change. Since the report covers 2 years, the formula should also sense what year it is. The formula I've created with IF(AND) does not work so perhaps someone can help me here?
Also, instead of returning a zero (0) value when month is current, it would be good it it could return a "text" instead.
I've attached the file where you can see my formula (B3:Y3)
Any help is highly appreciated!
Bookmarks