Why does difference between same dates shows a difference of 1 month in Excel

0 votes

Please take a look at the figure.

The value in cell A3 is the difference between the values in cell A1 and cell A2.

Please clarify why the month value is 01 when it should be zero as the month values are similar in A1 and A2. (All three cells have a date format.)

enter image description here

Mar 24 in Others by narikkadan
• 63,040 points
53 views

1 answer to this question.

0 votes
That's because you formatted the output using the same 'dd-mm-yy' format as the input. As a result, you are instructing Excel to use dates rather than integers.

Excel was created on January 1, 1900. The number 1 is represented as a date in this sentence. Hence, 0 == 0-1 1900. Making the formatting mm-dd-yy == 00-01-00
answered Mar 24 by Kithuzzz
• 38,010 points

Related Questions In Others

0 votes
1 answer

Excel - Make a graph that shows number of occurrences of each value in a column

There is probably a better way to ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,040 points
2,344 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8, 2022 in Others by gaurav
• 22,980 points
192 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,040 points
2,186 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,040 points
194 views
0 votes
1 answer

Excel formula to convert EST date time into IST date time?

The code: =IF(A1-TIME(10,30,0)<0,ABS(1+A1-TIME(10,30,0)),A1-TIME(10,30,0))  It works if your cell ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 63,040 points
130 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,630 points
375 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,630 points
698 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,630 points
354 views
0 votes
1 answer
0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

answered Mar 21 in Others by Kithuzzz
• 38,010 points
187 views
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