Sunday
Thanks.....that's what I was looking for
"Lars-Åke Aspelin" wrote in message
...
On Sun, 30 Mar 2008 12:04:43 +0100, "Dale" wrote:
This is probably a very basic question so I apologise first, how would I
calculate the last sunday of a given month? Once I have that date, I need
the following Friday......
Thanks
With the month, e.g. 2008-03 in cell A1try the following formula:
=DATE(YEAR(A1),MONTH(A1)+1,0)+1-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0))
The following Friday can be obtained by just adding 5 to the above
Hope this helps / Lars-Åke
|