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

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
 
P

Peo Sjoblom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top