Forum Discussion

Copper Contributor

Dec 24, 2019

Solved

IF function with dates

Hi - I have a spreadsheet keeping track of dates training courses are completed - I am trying to include the IF function to add a tick if the date the course was completed is before the due date, but...

Book1.xlsx10 KB

Formulas and Functions

SergeiBaklan
Dec 24, 2019
blondee0403

I'd remove helper cell and link to Due By

=IF((G6<F6)*(G6>1),CHAR(80),"")
Book1 (11) (2).xlsx19 KB

SergeiBaklan

Diamond Contributor

Dec 24, 2019

blondee0403

I'd remove helper cell and link to Due By

=IF((G6<F6)*(G6>1),CHAR(80),"")

Book1 (11) (2).xlsx19 KB

blondee0403
Copper Contributor
Jan 02, 2020
Sorry about the slow response but I'm only just back to work today. Thank you very much, that's exactly what I wanted!!
- SergeiBaklan
  Diamond Contributor
  Jan 02, 2020
  blondee0403 , hope you had great holidays, happy New Year!