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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 23, 2016 at 11:57 AM
Related:
- Calculate no of days left from today to a future specified date
- A little to the left free download mac - Download - Puzzle
- Left 4 dead 2 download - Download - Shooters
- Google sheet right to left - Guide
- How to calculate 90 days from date in excel - Guide
- Skype last seen days ago - Guide
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
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
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
555
Aug 23, 2016 at 11:57 AM
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
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
