Dec 03, 2017 07:07 AM
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?
Dec 03, 2017 08:01 AM
Something like this:
The formula in the In 2016 column would be:
IF(YEAR({Date Field})=2016,“Yes”,“No”)
Hope this helps!!
Dec 03, 2017 08:38 AM
That worked, thanks!