Posted to microsoft.public.excel.worksheet.functions

Carpe Diem Carpe Diem is offline

external usenet poster

Posts: 28

Problem with dates

Hi ,

I have the following dates:

31/03/2007
30/10/2006
09/12/1991

and I would like to check how many months do I have between dates, If
I use the year frac between the first and second will give 5 months
but the real value sholud be 6 . Can someone have a formula to check
this ?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dates problem	mita	Excel Discussion (Misc queries)	4	June 2nd 06 12:19 PM
Dates Problem	nicole0904	Excel Discussion (Misc queries)	5	May 10th 06 02:47 PM
Problem with dates	Andibevan	Excel Discussion (Misc queries)	1	December 1st 05 01:24 PM
Problem Dates	Andy Cohen	Excel Discussion (Misc queries)	1	September 16th 05 01:29 AM
Problem with dates	Emece	Excel Worksheet Functions	7	December 22nd 04 06:47 PM

All times are GMT +1. The time now is 01:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us