Posted to microsoft.public.excel.worksheet.functions

musha-bsuha[_2_] musha-bsuha[_2_] is offline

external usenet poster

Posts: 1

Counting calendar days

When I count calendar days, using =VALUE(B2-A2) or even just =(B2-A2), it
always omits one day. For instance 28/09/2009 to 30/09/2009 the formula
counts it as 2 days, while actually it's 3 days (28-29-30). How can I correct
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
Counting calendar Days - not including Sundays	KenCanuck	Excel Discussion (Misc queries)	3	April 28th 09 05:46 PM
Is there a formular for calendar days	Abi	Excel Discussion (Misc queries)	2	September 8th 08 04:43 PM
Calendar days	D	Excel Worksheet Functions	1	March 1st 07 08:24 AM
Calendar day not days	skip	New Users to Excel	2	September 22nd 06 11:16 PM
Calendar Days and Option Buttons	Andy	Excel Discussion (Misc queries)	0	January 10th 06 09:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us