Annual leave help :)

TheMSsForum.com: The Microsoft Software Forum

Hey,
I am doing an exel sheet concerning the annual leave and i am trying
to figure out a formula that
gives the total vacation days excluding Saturday and sunday

I have tried this formula but its not working so what can i do ?

IF (TotalDays Mod 7) * 7 = 6 Then WeekEndDays = WeekEndDays + 1
Please advise
Start date =B
End Date=C
Total = D


Please advise
Top

RE: Annual leave help :) by CoreyThomasMCSEMCSAMCDBA

CoreyThomasMCSEMCSAMCDBA
Thu Mar 13 08:53:05 CDT 2008

Hey Tia,

There is an entire group on here dedicated to Excel formulas (link below).
If those groups aren't active enough, please let me know and I can find it
for your. I know it can be done with VBScript, but Excel uses some forumlas
that are not in VBScript.


microsoft.public.excel.worksheet.function
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.worksheet.functions&cat=en_us_b5bae73e-d79d-4720-8866-0da784ce979c&lang=en&cr=us

microsoft.public.exce
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel&cat=en_us_a09d72a4-715e-4c37-bcd5-75e0fc616b1f&lang=en&cr=us

"tia.abdelkarim@gmail.com" wrote:

> Hey,
> I am doing an exel sheet concerning the annual leave and i am trying
> to figure out a formula that
> gives the total vacation days excluding Saturday and sunday
>
> I have tried this formula but its not working so what can i do ?
>
> IF (TotalDays Mod 7) * 7 = 6 Then WeekEndDays = WeekEndDays + 1
> Please advise
> Start date =B
> End Date=C
> Total = D
>
>
> Please advise
>
Top

Re: Annual leave help :) by Dr

Dr
Fri Mar 14 12:09:06 CDT 2008

In microsoft.public.scripting.vbscript message <bb1cabb8-1f57-4114-b95d-
e4e340a044a4@v3g2000hsc.googlegroups.com>, Thu, 13 Mar 2008 02:07:32,
tia.abdelkarim@gmail.com posted:
>Hey,
>I am doing an exel sheet concerning the annual leave and i am trying
>to figure out a formula that
>gives the total vacation days excluding Saturday and sunday
>
>I have tried this formula but its not working so what can i do ?
>
>IF (TotalDays Mod 7) * 7 = 6 Then WeekEndDays = WeekEndDays + 1


Consider leave from the 1st to the 4th of a month, this year. If it was
February, two working days would have been missed; if April, four
working days missed. That is, assuming the weekend is Sat & Sun; if you
are dealing with a Muslim country, you may need different months.

Clearly, therefore, the total of days spanned does not provide
sufficient information.

Determine the number of days missed in the first week and, if different,
the last week, and to that add five times the number of complete weeks
missed.

--
(c) John Stockton, nr London, UK. ?@merlyn.demon.co.uk Turnpike v6.05.
Web <URL:http://www.merlyn.demon.co.uk/> - w. FAQish topics, links, acronyms
PAS EXE etc : <URL:http://www.merlyn.demon.co.uk/programs/> - see 00index.htm
Dates - miscdate.htm moredate.htm js-dates.htm pas-time.htm critdate.htm etc.
Top