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
1	1/16/2019	Due Today
2	1/21/2019	Due in 5
3	1/10/2019	Overdue

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =IF(A1=TODAY(),"Due Today",IF(A1>TODAY(),"Due in "& A1 - TODAY() & " days","Overdue")) <tbody> </tbody>

<tbody>
</tbody>

 

[Ian Cowden]

Thank you so much fhqwgads. That solves my problem.

Very much appreciated

Ian