DATES CALCULATION

[JUALOP60]

Hi,

I have a formula:

=Networkdays(g16,g19) on H20,

my problem is this,

From this above results I want a formula and cell h25 also to calculate in which payday are those vacations days fallen.

Our period is like that:

from 8-24 is pay on first day of next month,

from 25-7 is pay on fifteen of the month.

for example if it's June 24 to June 24, 2010 so will be

paid on July 1, 2010, June 25 to July 7, will paid on July 15th, 2010.

so i want a formula to fill in these two fields in my excel template here a what it is:

IF ON VACATION DURING A PAY PERIOD, REQUEST FOR PAY CHEQUE:


July - 2010
a) On the First of _______________

Month

b) On the Fifteenth of July - 2010
______________
Month

thank you very much for your help.

 

[kjv1611]

For some help, in case you didn't already look at it, there's a helpful FAQ on dealing with dates in Excel on this forum:
faq68-5827

It's an overall view of dates. Have a look at the FAQs for more help in the same area, under Dates...

http://www.tek-tips.com/faq.cfm?pid=68

Also, to get more help on this, how about telling us which version of Excel you are using (probably won't matter for this one, but just in case), as well as an example of "Here's all the original data, as it would be in the worksheet", and "here's what I want the formula Cells to show".. whatever you can share in that are would help.

It may just be my own brain right now, but to me, the whole question did give a lot of information, but was presented in such a way that it is difficult to follow.

 

[SkipVought]

Please post a concrete example of what you have on your sheet and what you also want to see.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[JUALOP60]

Hi,

This is what i have, on sheet i want by the dates to know which payday period fall on vacation days taken.
EMPLOYEE NAME: JOSE I #VALUE! #VALUE! DEPARTMENT: ACCOUNTING #VALUE! #VALUE!

Wednesday
VACATION START DATE: June 16 2010
MONTH DAY YEAR
Thursday
RETURNING TO WORK ON: June 17 2010
MONTH DAY YEAR

Number of Working Days Absent: 2

IF ON VACATION DURING A PAY PERIOD, REQUEST FOR PAY CHEQUE:

a) On the First of
Month


or b) On the Fifteenth of
Month

 

[SkipVought]

1. you did not show exactly what value(s) you want returned for the posted example.

2. Jose, having taken June 16, 2010 as vacation and returning June 17, 2010, has only ONE Working Days Absent; not TWO.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}