DATEDIF Excel - output incorrect

0 votes

Using the DATEDIF function in Excel, I'm trying to figure out how much two dates differ from one another. I get the wrong output when I try to do it.

I am wanting the difference in days, but the output is way off

How can I fix this? I am trying to get the difference in days - e.g., 26 days

I tried the formula and was expecting to receive the output of 26 days

Dec 28, 2022 in Others by Kithuzzz
• 27,740 points
50 views

1 answer to this question.

0 votes
If you want the difference in days, just subtract one from the other; you don't need DATEDIF for that. If you want the number of working days then networkdays.intl() will do that and again M4 - H4 seems a better option compared to the substitute option shown - perhaps I just don't like typing :)
answered Dec 28, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

Excel pace formula gives incorrect answers

6.3 is correct answer just not in ...READ MORE

answered Jan 9 in Others by narikkadan
• 51,240 points
84 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

answered Jan 24 in Others by narikkadan
• 51,240 points
39 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

answered Jan 24 in Others by narikkadan
• 51,240 points
41 views
0 votes
2 answers
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
206 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,640 points
373 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,640 points
168 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
148 views
0 votes
1 answer

Why percentage calculation in excel gives me incorrect numbers

Please be specific with your query. Do ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 51,240 points
78 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP