showing number of days apart from today

[Enzo_Matrix]

I am updating a table for a production schedule and I want to automatically tell how many days away an order is due from today without looking at the dates and counting.
Is there something that can do this while still keeping the date as well?

Jan 1, 2018 - 9
Jan 10, 2018 - Today
Jan 12, 2018 +2

 

[Scott Huish]

You can just subtract them.

Excel 2010
	A	B
1	1/1/2018	-9
2	1/10/2018
3	1/12/2018	+2
Sheet1

Cell Formulas
Range	Formula
B1	=A1-$A$2
B3	=A3-$A$2

Format the cells as:
+0;-0;0

 

[Roderick_E]

Let's suppose your dates are in column B, on each row. In column C you could have this code

=b1-today()

Drag down the formula

Format column C as general or number. It will give you how many days you have until the date in column B.

 

[Enzo_Matrix]

Is there a way to add that into VBA?

 

[Scott Huish]

Are you actually subtracting from TODAY() or from the cell in A2 as in your example?

 

[Enzo_Matrix]

I do have the dates listed in Column 'G' and in column 'H' I want to show a difference, numerically, from the listed date to today's.

I manually input the formula and it does work, but not as cleanly as I'd like

=$G2-Today()

 

[Scott Huish]

This will put the value in H2 downward for every value in column G:

Sub TodayDifference()
With Range("H2:H" & Range("G" & Rows.Count).End(xlUp).Row)
    .Formula = "=G2-Today()"
    .Value = .Value
    .NumberFormat = "+0;-0;0"
End With
End Sub