Search : in
By :

Dates in Excel

Last answer on Oct 1, 2009 1:23:48 am BST Artemis33, on Sep 30, 2009 1:23:02 am BST 
 Report this message to moderators

Hello,

I am having the hardest time with what seems to be a simple problem in Excel 2003...

I have this formula:
IF(C4<($C$1-90),$D$1-$C$1,$D$1-(C4+90))

Where C4 = March 8, 2004
C1 = September 1, 2008
D1 = August 31, 2009

The result cells are formatted as: m "months", d "days";@

The problems is that the result is shown as "12 months, 29 days"... It should show 12 months.

Am I missing a step or doing something wrong?

Thanks a bunch for any help you can provide!

Configuration: Windows Vista
Firefox 3.5.3

Best answers for « Dates in Excel » in :
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Excel tips : How to insert date In an Excel cell ShowExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Ask your question Reply

1

venkat1926, on Sep 30, 2009 3:14:11 am BST

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")

   
Reply to venkat1926

2

Artemis33, on Sep 30, 2009 10:30:31 am BST

Thank you for your response.

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!

   
Reply to Artemis33

3

 venkat1926, on Oct 1, 2009 1:23:48 am BST

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.

   
Reply to venkat1926
Ask your question Reply
They need your help