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
• 38,010 points
307 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
• 63,420 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, 2023 in Others by narikkadan
• 63,420 points
5,149 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, 2023 in Others by narikkadan
• 63,420 points
822 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, 2023 in Others by narikkadan
• 63,420 points
366 views
0 votes
1 answer

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

answered Feb 4, 2023 in Others by narikkadan
• 63,420 points
647 views
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,670 points
1,017 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,670 points
1,333 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,670 points
653 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
• 23,260 points
2,144 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
• 63,420 points
509 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