Excel 2016 DATEDIF Function Issues - Microsoft Community


my datedif function returning date opposed number of days in between specified dates.

here's function:   =datedif(b5,c5,"d")

and here's function returning (b5 , c5 first 2 cells, respectively. third cell output of above function):

6/4/2018 6/6/2018 1/2/1900

the function should returning thenumber two, not date. i've tried reformatting date "style" of cells no avail. 

here's full grid. maybe more examples show what's going on here! in advance help.

6/4/2018 6/6/2018 1/2/1900
6/7/2018 6/8/2018 1/1/1900
6/11/2018 6/15/2018 1/4/1900
6/18/2018 6/22/2018 1/4/1900
6/25/2018 6/29/2018 1/4/1900

mitchell, change format of cell numeric shows value integer rather date.


Office / Excel / Windows 10 / Office 2016



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community