Posted to microsoft.public.excel.misc

Hassan

external usenet poster

Posts: 75

Difference between dates

Hi All,

I need one help for date formula, I have employee sheet where the leave
sheet is, if the leave start from 1st of june and end 15th of June, so the
leaves are 15 days but when we apply formula e.g. B1-A1 then its return 14
not 15. what formula we can use to get accurate data?

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
Difference between dates	Khurum	Excel Worksheet Functions	12	August 13th 08 12:53 AM
Difference between two dates	Ashutosh	Excel Discussion (Misc queries)	8	June 2nd 07 01:19 AM
difference between dates	Clash	Excel Discussion (Misc queries)	4	May 26th 06 08:02 AM
difference between dates	dcccgoose	Excel Discussion (Misc queries)	3	May 15th 06 03:34 AM
difference between two dates	dhouston1000	Excel Discussion (Misc queries)	2	August 24th 05 11:19 AM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us