Days Function - #Value error

[AthmanArumugam]

Hi,

I am getting a value error for the formula =Days(today(),"15/04/1982") in my workbook. The same formula works well in my colleague workbook. What is the possible root cause of this issue.

 

[vletm]

Which version of Excel do You use?
My version do not have that formula.
=Days360(startdate,enddate,..)

 

[rahulshewale1]

hii,

DAYS formula available in excel 2013. formula may be like below? first put month then day.

=DAYS(TODAY(),"04/15/1982")


Thanks
Rahul shewale

 

[AthmanArumugam]

hii,

DAYS formula available in excel 2013. formula may be like below? first put month then day.

=DAYS(TODAY(),"04/15/1982")


Thanks
Rahul shewale

The above solution worked. How to change the settings to mm/dd/yyyy in excel so that any user who opens it will get the result.

 

[AthmanArumugam]

Which version of Excel do You use?
My version do not have that formula.
=Days360(startdate,enddate,..)

I use excel 2013.

 

[vletm]

@AthmanArumugam
https://support.office.com/en-us/ar...0f07bff0b9df?ui=en-US&rs=en-US&ad=US&fromAR=1

If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value.

 

[Chihiro]

The above solution worked. How to change the settings to mm/dd/yyyy in excel so that any user who opens it will get the result.

That's based on your system's regional setting. Check the time/date format there. It should be set to "M/d/yyyy" for short date.

Edit:
However, it's far safer to use DATE() function rather than string when working with dates in Excel like below. It will adjust to any date format.
=DAYS(Today(),Date(1982,4,15))