Calculate no of days left from today to a future specified date [Solved/Closed]

Report
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
Hello,


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

2 replies

Posts
1926
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 12, 2021
143
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
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!