I need to create a column which applies a formula only when another column is between certain dates. For example, if column A is a date, I want column B to apply a formula only if A is a date in 2015; I want column C to apply a formula only if column A is in 2016, etc. What would the coding of this kind of formula be?
Something like this:
The formula in the In 2016 column would be:
Hope this helps!!
That worked, thanks!