Dates in Excel
Closed
Artemis33
-
29 Sep 2009 à 20:23
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 30 Sep 2009 à 20:23
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 30 Sep 2009 à 20:23
Related:
- Dates in Excel
- Excel mod apk for pc - Download - Spreadsheets
- Apple iphone 13 release dates - Guide
- Excel online macros - Guide
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
29 Sep 2009 à 22:14
29 Sep 2009 à 22:14
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
30 Sep 2009 à 20:23
30 Sep 2009 à 20:23
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.
30 Sep 2009 à 05:30
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!