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

raghs - Aug 23, 2016 at 07:17 AM - Latest reply: TrowaD 2345 Posts Sunday September 12, 2010Registration dateModeratorStatus April 23, 2018 Last seen
- Aug 23, 2016 at 11:57 AM
Hello,


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

2 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 23, 2016 at 11:57 AM
0
Helpful
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
TrowaD 2345 Posts Sunday September 12, 2010Registration dateModeratorStatus April 23, 2018 Last seen - Aug 23, 2016 at 11:57 AM
0
Helpful
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