Forum Discussion

dls2019's avatar
dls2019
Copper Contributor
Jun 20, 2019

If and formula where the criteria are dates

I need a formula that will pull the value in a cell if date is between 2 values

 

example:  if C2 (date) is >= January 1, 2018 and also <= May 31, 2018, then I need the value, but 0 if not.  I tried =if(and(C2>=01/01/2018,C2<=05/31/2018),E2,0) but it didn't work.  do I need to convert the date to a number?

No RepliesBe the first to reply

Resources