days remaining

Jagat Pavasia

Board Regular
Joined
Mar 9, 2015
Messages
208
Office Version
  1. 2019
Platform
  1. Windows
I have date in my F1 like 12/03/2019 dd/mm/yyyy.

I want formula in H1 that how much days remaining from currant date of today.


Today is 08/03/2019, so answer in H1 should be "4".

and tomorrow this H1 should be "3", automatic by formula
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
2,843
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
H1 = F1 - Today()

Be sure to format H1 as 'General' because it will automatically format it as a date and look like '5/1/1900'.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,880
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top