Subtract days

[numerion]

I need to input a future date and with that date I need excel to display the days left before the date expires? Can anyone help me. Thanks

numerion

[RJL0323]

Lets say the cell you are inputting the future date into is A1. The amount of days left before the date in A1 expires is in B1. One possible solution in B1:

=A1-today()

Please keep in mind that since you are referring to a date format in A1, you will need to change cell B1 to a number format in order for it to display the number days left.

Let me know if this works.

[numerion]

That is what I need, Thanks