Report

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

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
Leave a comment
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

Leave a comment

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!