Compare Dates

[Ian Cowden]

I would like to compare a date to today to display the following where the date is in cell A1


If A1=Today then "Due Today"
If A1 Greater than Today then "Overdue"
If A1 Less than Today then "Due in x Days"(where x is the number of days until the date in A1)


Any ideas


Ian

 

[fhqwgads]

did you mean to swap greater and less than?
if the date in A1 is greater than today it should be in the future

 

[Ian Cowden]

Yes, sorry.

 

[fhqwgads]

maybe like this?

Book1
	A	B
1	10/01/2019	Overdue
2	16/01/2019	Overdue
3	17/01/2019	Due Today
4	22/01/2019	Due in 5 days
5	28/01/2019	Due in 11 days
6	3/02/2019	Due in 17 days
7	9/02/2019	Due in 23 days
Sheet32

Cell Formulas
Range	Formula
B1	=IF(A1=TODAY(),"Due Today",IF(A1),"Overdue","Due in "&A1-TODAY()&" days"))

 

[jim may]

Copy Down Formula in Cell B1

Excel 2010

	A	B

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]1/16/2019[/TD]
[TD="align: center"]Due Today[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1/21/2019[/TD]
[TD="align: center"]Due in 5[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1/10/2019[/TD]
[TD="align: center"]Overdue[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=IF(A1=TODAY(),"Due Today",IF(A1>TODAY(),"Due in "& A1 - TODAY() & " days","Overdue"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ian Cowden]

Thank you so much fhqwgads. That solves my problem.

Very much appreciated

Ian