Excel 2016 DATEDIF Function Issues - Microsoft Community
Office / Excel / Windows 10 / Office 2016
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 |
Office / Excel / Windows 10 / Office 2016
Comments
Post a Comment