• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Datedif giving #Value Error

Status
Not open for further replies.
S

skorpion

New Member
I have Excel where im using hijri dates and want to know th differnece betwwen two dates i used datedif funcaton bit geeting #Value error please some one can help me out on this
 

Attachments

  • Copy of محطات مهلة 3 شهور-1.xlsx
    159.5 KB · Views: 6
skorpion
Is this duplicate with below?

Datedif funcation error on Negative Values

im trying to get the value that how many year month and days remaining and i used datediff but problem is when end date is greater then start date its giving me error here is the formula =DATEDIF(DATEDIF(today(),U2,"ym") &" months," &DATEDIF(today(),U2,"md") &" days" so when its negative i...
chandoo.org
 
Status
Not open for further replies.
Back
Top