Help showing active months between two dates

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by ChooseParkay

Yes but when I use this formula it only counts WHOLE months

For example if it were 09/25..... 11/3 the =dateif would only read as 1
I would need it to read as 3 because for this purposes they were with us 3 months

A very simplified way of doing it, but I think this should work for you...

Attached Files

ChooseParkay Example.zip (5.8 KB, 77 views)

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
Help showing active months between two dates	ChooseParkay	Excel Discussion (Misc queries)	3	July 30th 12 07:39 PM
Showing Lists in active cell	Spuds Glorious Spuds[_2_]	Excel Discussion (Misc queries)	4	December 4th 08 11:13 PM
Stop dates from showing as numbers - when formated as dates	JR	Excel Discussion (Misc queries)	1	October 29th 08 04:38 PM
Adding months to dates should account for 28-30-31 day months	Graham	Excel Worksheet Functions	3	February 1st 06 12:06 PM
Dates to months and calculating values for their months	jigsaw2	Excel Programming	1	September 5th 03 01:35 PM

All times are GMT +1. The time now is 09:50 PM.

Menu

About Us