Dates in Excel
Closed
Artemis33
-
Sep 29, 2009 at 08:23 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 30, 2009 at 08:23 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 30, 2009 at 08:23 PM
Related:
- Dates in Excel
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 29, 2009 at 10:14 PM
Sep 29, 2009 at 10:14 PM
I am not sure
perhaps the mistakes comes in formatting as months and daysl
the dates in excel are actually number (days from 1 jan 1900 or something like that )
if you format it as days it will be 364 days.
if you convert this into months and days there will be problem.are you going to divide by 30 or 31 or 29 or 28.
try this formula
=datedif(c1,d1,"d")
perhaps the mistakes comes in formatting as months and daysl
the dates in excel are actually number (days from 1 jan 1900 or something like that )
if you format it as days it will be 364 days.
if you convert this into months and days there will be problem.are you going to divide by 30 or 31 or 29 or 28.
try this formula
=datedif(c1,d1,"d")
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 30, 2009 at 08:23 PM
Sep 30, 2009 at 08:23 PM
Is this not semantic problem? 5 minus 1 is 4. the difference means incremental. sep 1 to sep 5 th is only 4 days. think about it closely.
Sep 30, 2009 at 05:30 AM
Even though I need the result to show in months and days, I had tried =datedif(c1,d1,"d"), but that comes out as 364 days... However, it should show 365 days (and 366 days if February 2008 were included in the time frame).
Is there any way for Excel to accurately count the number of months and days between two dates? If so, how.
Thank you!