PDA

View Full Version : Solved: Every Friday in a month



CCkfm2000
11-01-2005, 02:39 AM
hi all..

i have a spreadsheet register i need to print every start of the month. what i need is to get every friday for that month in the sheet.
so far i've managed to get this far.
in a1 i enter the date 31/10/05
in f1 i have =IF(OR(WEEKDAY(A4+1)=1,WEEKDAY(A4+1)=7),A4+3,A4+4)
in g1 i have +f1
in h1 i have +g1
in i1 i have +h1
in j1 i have +i1

this get the result what i need but then if the month has only 4 fridays it displays the next month with it.

can it be an automatic process from the system date?


help :dunno

Bob Phillips
11-01-2005, 03:14 AM
hi all..

i have a spreadsheet register i need to print every start of the month. what i need is to get every friday for that month in the sheet.
so far i've managed to get this far.
in a1 i enter the date 31/10/05
in f1 i have =IF(OR(WEEKDAY(A4+1)=1,WEEKDAY(A4+1)=7),A4+3,A4+4)
in g1 i have +f1
in h1 i have +g1
in i1 i have +h1
in j1 i have +i1

this get the result what i need but then if the month has only 4 fridays it displays the next month with it.

can it be an automatic process from the system date?


help :dunno

Your formulae look off-track to me

F1: =DATE(YEAR(TODAY()),MONTH(TODAY()),8)-WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),2))
G1: =IF(MONTH(F1+7)=MONTH(F1),F1+7,"")
H1: =IF(MONTH(G1+7)=MONTH(G1),G1+7,"")
I1: =IF(MONTH(H1+7)=MONTH(H1),H1+7,"")
J1: =IF(MONTH(I1+7)=MONTH(I1),I1+7,"")

CCkfm2000
11-01-2005, 03:45 AM
great work. thanks