Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula question
if I have a date in colum A and a date in colum B, what would the formula be
to find out how many months inbetween the two dates? -- fiona05 |
#2
|
|||
|
|||
Morning Fiona Set up the formula so (eg) =B1-A1 and format the cell using FORMAT/CELLS/NUMBER select CUSTOM and enter in the TYPE box this: mm This gives you whole months between dates and might not be as accurate as you might need Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=471660 |
#3
|
|||
|
|||
Hi Fiona,
The correct answer is going to depend on how well you want to define what constitutes a months worth of days. Not all months have the same number of days. If you start on the the 31st and end on the last day of the next month with 30 days was that a month, if you go to the 1st day of the next month do you then have one month. Likewise if you start at the end of a 30 day month and end at the 30th of a 31 day month do you have a month or are you a day short of month. Take a look at DATEDIF it will probably do what most people would expect as an answer. If you have Excel 2000 (and I think Excel 2003) you will find it in HELP otherwise you won't (don't know about MACs). In any case it has always been in Excel and was once documented in the MS KB as the "Undocumented Function" then they removed the article.. Anyway whether or not it is in your Excel HELP, you should look at Chip Pearson's page, which has some additional explanations, and examples: http://www.cpearson.com/excel/datedif.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Fiona" wrote in message ... if I have a date in column A and a date in column B, what would the formula be to find out how many months inbetween the two dates? -- fiona05 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |