automating months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.

Will that do?

Mike
 
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.
 
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.
 
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")
 
Back
Top