Date Interval

[shers]

Hi all,

I would like to get the sunday date of every week starting from the first day of month, for 8 weeks. Is this possible?

Thanks

[daddylonglegs]

You could do that like this.

If A1 contains the 1st of the first month, e.g. 1-Jul-2008

then use this formula in A3

=A1+7-WEEKDAY(A1-1)

Then in A4 copied down to A10

=A3+7

[shers]

Thanks. That worked.