Posted to microsoft.public.excel.misc

Marci[_2_] Marci[_2_] is offline

external usenet poster

Posts: 2

Datedif formula

I am trying to figure out the number of months between a start date and the
current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it
is giving me the wrong answer. Ex. the start date is Sep-07 and it is
returning 1291 as an answer and the column is formatted as number. Can you
please help me. Thanks

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
about this formula =DATEDIF(J5,H5,"d")	insting	Excel Discussion (Misc queries)	4	September 25th 07 01:46 PM
DATEDIF	Deborah	Excel Worksheet Functions	11	September 12th 07 04:06 PM
DATEDIF formula enhancement	Santa-D	Excel Worksheet Functions	10	November 9th 06 01:14 PM
DateDif Average? Damn DateDif	UTCHELP	Excel Worksheet Functions	14	November 17th 05 10:30 AM
=DATEDIF(B14,B4,"m")	teeb	Excel Discussion (Misc queries)	1	July 20th 05 11:52 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us