YEAR MONTH DAYS COUNTER

[ad2ad79ster]

Hi,
I have a sheet in which I want to count the year then month and then
days for employee. i.e

Name Date of joining Date of leaving Absent Total
JOHN 23-08-2001 11-11-2008 15 Years-Months-Days


I want that Function or formula count first Rounded Year from
23-08-2001 23-08-2008 then count Month and then days. and then minus
Absent days and final result. Pls help me.

Best Regards.

 

[Gerry]

You have also posted to microsoft.public.excel.misc, which is a very
active newsgroup. This is a far more suitable than
microsoft.public.windowsxp.newusers. In future if you feel the need to
post to more than one newsgroup ( there are occasions when this is
appropriate ) please crosspost and do not multi-post your message.

"Avoid posting to multiple newsgroups.
Few things annoy Usenet readers as much as multiple copies of a posting
appearing in multiple newsgroups (called "spamming"). A posting that is
cross-posted (i.e. lists multiple newsgroups on the Newsgroups: header
line) to a few appropriate newsgroups is fine, but even with
cross-posts, restraint is advised."

Source:
http://groups.google.com/support/bin/answer.py?hl=en&answer=46492

To crosspost using Outlook Express you enter each newsgroup address as
illustrated next.
microsoft.public.windowsxp.newusers,microsoft.public.excel.misc

The addresses are entered in the newsgroups box in the composition
window. Each newsgroup has to be separated from the other by a comma.

You should find out how to crosspost using your existing news reader or
get a better news reader if you intend to send the same question to more
than one newsgroup.


--


Hope this helps.

Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[ad2ad79]

You have also posted to microsoft.public.excel.misc, which is a very
active newsgroup. This is a far more suitable than
microsoft.public.windowsxp.newusers. In future if you feel the need to
post to more than one newsgroup ( there are occasions when this is
appropriate ) please crosspost and do not multi-post your message.

"Avoid posting to multiple newsgroups.
Few things annoy Usenet readers as much as multiple copies of a posting
appearing in multiple newsgroups (called "spamming"). A posting that is
cross-posted (i.e. lists multiple newsgroups on the Newsgroups: header
line) to a few appropriate newsgroups is fine, but even with
cross-posts, restraint is advised."

Source:http://groups.google.com/support/bin/answer.py?hl=en&answer=46492

To crosspost using Outlook Express you enter each newsgroup address as
illustrated next.
microsoft.public.windowsxp.newusers,microsoft.public.excel.misc

The addresses are entered in the newsgroups box in the composition
window. Each newsgroup has to be separated from the other by a comma.

You should find out how to crosspost using your existing news reader or
get a better news reader if you intend to send the same question to more
than one newsgroup.

--

Hope  this helps.

Gerry
 ~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~








- Show quoted text -

Thanks ... Well Noted...

 

[ad2ad79]

You have also posted to microsoft.public.excel.misc, which is a very
active newsgroup. This is a far more suitable than
microsoft.public.windowsxp.newusers. In future if you feel the need to
post to more than one newsgroup ( there are occasions when this is
appropriate ) please crosspost and do not multi-post your message.

"Avoid posting to multiple newsgroups.
Few things annoy Usenet readers as much as multiple copies of a posting
appearing in multiple newsgroups (called "spamming"). A posting that is
cross-posted (i.e. lists multiple newsgroups on the Newsgroups: header
line) to a few appropriate newsgroups is fine, but even with
cross-posts, restraint is advised."

Source:http://groups.google.com/support/bin/answer.py?hl=en&answer=46492

To crosspost using Outlook Express you enter each newsgroup address as
illustrated next.
microsoft.public.windowsxp.newusers,microsoft.public.excel.misc

The addresses are entered in the newsgroups box in the composition
window. Each newsgroup has to be separated from the other by a comma.

You should find out how to crosspost using your existing news reader or
get a better news reader if you intend to send the same question to more
than one newsgroup.

--

Hope  this helps.

Gerry
 ~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~








- Show quoted text -

Hi Gerry,

Actually I was trying 2 add each n every group related 2 excel
2007.. .. and I've added 6 groups in my group list... Unfortunately..
I really don't know that really these all groups r same... actually
some groups shows me that I can't post any msg.... should I have 2
delete that groups from my group list..????

 

[Gerry]

ad2ad79

You're welcome and thanks for acknowledging my post.

--


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~

 

[Gerry]

ad2ad79

What newsreader are you using?



--


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~