Create an if/then formula using dates


#1

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?


#2

Something like this:

24

The formula in the In 2016 column would be:

IF(YEAR({Date Field})=2016,“Yes”,“No”)

Hope this helps!!


#3

That worked, thanks!