Skip to main content

Create an if/then formula using dates

  • December 3, 2017
  • 2 replies
  • 44 views

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?

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+4

Something like this:

The formula in the In 2016 column would be:

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

Hope this helps!!


  • Author
  • New Participant
  • December 3, 2017

That worked, thanks!