If Statement in Excel with Dates

February 26, 2013 at 10:36:44
Specs: Windows 20.06.2011

I am trying to do the following:

If the date is before 1/1/2014 in cell I15 I want cell J15 to say "yes". If the date is after 1/1/2014 in cell I15 I want cell J15 to say "no".

Then, in another cell, I want if cell I15 is between 1/1/2014 and 1/1/2015 I want the value in G15 to be placed in cell K15.


See More: If Statement in Excel with Dates

Report •


#1
February 26, 2013 at 13:20:07

For the J15 formula, what do you want to return if the date in I15 is equal to 1/1/2014?

The same question holds for the formula in K15: What if the date equals one of the 2 dates that you are checking for?

BTW, the solution will be based on the IF function. Have you read anything on the IF function in the Excel Help files or via a Goolge search?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question