Help

Create an if/then formula using dates

1886 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bantu_Design_Re
5 - Automation Enthusiast
5 - Automation Enthusiast

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 Replies 2

Something like this:

24

The formula in the In 2016 column would be:

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

Hope this helps!!

Bantu_Design_Re
5 - Automation Enthusiast
5 - Automation Enthusiast

That worked, thanks!