Is there an End of Week function similar to the EOMONTH?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I want to print a column of dates that only print the date
for each Saturday of each week, but at the end of the month
I need the last date of each month printed. The problem
that I'm have is getting the first Saturday of each month
to calculate from the previous month

i.e.
This is the fomulas entered into each cell
37987
=A1+7
=A1+14
=A1+21
=IF(A1+28>=EOMONTH(A1,0),EOMONTH(A1,0),A1+28)
=IF(A5=EOMONTH(A1,0),"",EOMONTH(A1,0))

=A1+35
=A8+7
=A8+14
=A8+21
=IF(A8+28>=EOMONTH(A8,0),EOMONTH(A8,0),A8+28)
=IF(A12=EOMONTH(A8,0),"",EOMONTH(A8,0))
This is want is displayed from the above formulas
01/01/04
01/08/04
01/15/04
01/22/04
01/29/04
01/31/04

02/05/04
02/12/04
02/19/04
02/26/04
02/29/04

Please reply
Thanks,
Chris
 
This is very easily done.
First cell (A1) put 01/03/04
In A2 put

=A1+7

copy down to 12/25/04 in cell A52
in A53 put

=DATE(2004,ROW(1:1)+1,0)

copy down to A64, select the lot and copy, paste special as values in place
and then
sore the list ascending Voila!

Now you can makes sure there are no duplicates (last day of the month is a
Saturday)
by either use the advanced filter and select unique records only or add a
bit to the last day of the month formula

=IF(WEEKDAY(DATE(2004,ROW(1:1)+1,0),2)=6,"",DATE(2004,ROW(1:1)+1,0))
 
Back
Top