automating months
 

is there a way to automate the dates for months in excell, e.g from the 1st
monday in a month to the last friday?

automating months
 

put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.

Will that do?

Mike

"Gunthar68" wrote:

is there a way to automate the dates for months in excell, e.g from the 1st
monday in a month to the last friday?

automating months
 

usefull but i need more of a "1/3/7-30/3/7" sort of thing:)
Gunthar


"Mike" wrote:

put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.

Will that do?

Mike

"Gunthar68" wrote:

is there a way to automate the dates for months in excell, e.g from the 1st
monday in a month to the last friday?

automating months
 

Specifying "sort of thing" is not designed to get you very useful results. When
you tell people exactly what you want, you will get an answer.

--
Regards,
Fred


"Gunthar68" wrote in message
...
usefull but i need more of a "1/3/7-30/3/7" sort of thing:)
Gunthar


"Mike" wrote:

put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.

Will that do?

Mike

"Gunthar68" wrote:

is there a way to automate the dates for months in excell, e.g from the 1st
monday in a month to the last friday?

automating months
 

cheers fred ) what i need is: an automated routine to write in the 1st
working day and the last working day of each month e.g. "1/3/7 - 30/3/7" for
each month. dont know if it's possible, mikes suggestion was very usefull for
calculating each working day that month bu i need a broader spectrum so a
report can be generated for each month. cheers Gunthar.

"Fred Smith" wrote:

Specifying "sort of thing" is not designed to get you very useful results. When
you tell people exactly what you want, you will get an answer.

--
Regards,
Fred


"Gunthar68" wrote in message
...
usefull but i need more of a "1/3/7-30/3/7" sort of thing:)
Gunthar


"Mike" wrote:

put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.

Will that do?

Mike

"Gunthar68" wrote:

is there a way to automate the dates for months in excell, e.g from the 1st
monday in a month to the last friday?

automating months
 

There may be better ways, but one solution is:

A1: Date with month in question
A2: =date(year(a1),month(a1),1) [First day in month]
A3: =date(year(a1),month(a1)+1,0) [Last day in month]
A4: =a2+choose(mod(a2,7)+1,2,1,0,0,0,0,0) [First working day of month]
A5: =a3-choose(mod(a2,7)+1,1,2,0,0,0,0,0) [Last working day of month}
A6: =text(a4,"dd/mm/yy")&" - "&text(a5,"dd/mm/yy")

--
Regards,
Fred


"Gunthar68" wrote in message
...
cheers fred ) what i need is: an automated routine to write in the 1st
working day and the last working day of each month e.g. "1/3/7 - 30/3/7" for
each month. dont know if it's possible, mikes suggestion was very usefull for
calculating each working day that month bu i need a broader spectrum so a
report can be generated for each month. cheers Gunthar.

"Fred Smith" wrote:

Specifying "sort of thing" is not designed to get you very useful results.
When
you tell people exactly what you want, you will get an answer.

--
Regards,
Fred


"Gunthar68" wrote in message
...
usefull but i need more of a "1/3/7-30/3/7" sort of thing:)
Gunthar


"Mike" wrote:

put the first couple of dates in and then select the range. The edit -
fill -
series and select weekday.

Will that do?

Mike

"Gunthar68" wrote:

is there a way to automate the dates for months in excell, e.g from the
1st
monday in a month to the last friday?