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

Solved/Closed
raghs - Aug 23, 2016 at 07:17 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 23, 2016 at 11:57 AM
Hello,

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

## 2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 23, 2016 at 11:57 AM
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 Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 23, 2016 at 11:57 AM
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