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
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