Calculate no of days left from today to a future specified date

[Solved/Closed]
Report
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
Hello,


How to calculate no of days left from today to a future specified date

2 replies

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
raghs, Good morning.

Suppose:
A1 --> TODAY()
B1 --> 08/23/2017

C1 --> B1-A1
Format C1 to NUMBER

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi Raghs,

Try this:
When specified date is in A1.
=A1-TODAY()
Excel automaicaly changes the cell format to Date, so change it's format back to default to show the actual days.

Best regards,
Trowa