Posted to microsoft.public.excel.misc

juancarlos juancarlos is offline

external usenet poster

Posts: 7

Count Between dates

How can I count between two dates when format for the dates is DD-MM-YY

I need to know how many days are between 21/04/09 and 28/04/09

The solution should be 8 if I use =(A2-A1+1) but Im getting #VALUE!

Im used format = Custom = dd/mm/yy, also General and Number but they are
not working either.

Any suggestions?

--
Juan Carlos

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
Count Dates between Dates exclude Text	Ken	Excel Discussion (Misc queries)	3	April 8th 09 07:59 PM
Count Dates	Matthew Tyrus	Excel Discussion (Misc queries)	2	October 16th 08 06:29 PM
I want to count the total Number of dates between two dates How?	seshu	Excel Worksheet Functions	3	February 7th 08 05:41 PM
Count Dates?	msnews.microsoft.com[_3_]	Excel Worksheet Functions	3	February 1st 08 05:22 PM
need to convert list of dates to count no. of dates by week	neowok	Excel Worksheet Functions	13	January 30th 06 03:54 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us