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?
monday in a month to the last friday?
G
Guest
put the first couple of dates in and then select the range. The edit - fill -
series and select weekday.
Will that do?
Mike
series and select weekday.
Will that do?
Mike
G
Guest
usefull but i need more of a "1/3/7-30/3/7" sort of thing
Gunthar
Gunthar
F
Fred Smith
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.
you tell people exactly what you want, you will get an answer.
G
Guest
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.
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.
F
Fred Smith
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")
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")