Report

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

Ask a question raghs - Last answered on Aug 23, 2016 at 11:57 AM by TrowaD
Hello,


How to calculate no of days left from today to a future specified date
See more 
Helpful
+0
plus moins
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
Helpful
+0
plus moins
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!