convert weekday date to the next sunday date

G

Guest

I am looking for a formula to convert the days of a week to the weekend date,
preferably Sunday, but a Saturday result will be OK.
I am needing to achieve the same type of result as as 'eomonth' but for
weeks(eoweek doesn't exist).

Eg.
Dates in week Monday 01/01/2007 to Sunday 07/01/2007 will return result
'Sunday 07/01/2007'
Dates in week Monday 08/01/2007 to Sunday 14/01/2007 will return result
'Sunday 14/01/2007'
 
N

Niek Otten

=A1+(7-WEEKDAY(A1,2))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am looking for a formula to convert the days of a week to the weekend date,
| preferably Sunday, but a Saturday result will be OK.
| I am needing to achieve the same type of result as as 'eomonth' but for
| weeks(eoweek doesn't exist).
|
| Eg.
| Dates in week Monday 01/01/2007 to Sunday 07/01/2007 will return result
| 'Sunday 07/01/2007'
| Dates in week Monday 08/01/2007 to Sunday 14/01/2007 will return result
| 'Sunday 14/01/2007'
 

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

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Formula to tell day of week 2
Count 1
Adjusting Date Results 7
Calculating Turn Around Times excluding Sunday 1
Determining the Sunday date of the third "full" weekend of a month 25
Finding the right function & formula 4
Finding the next dayof the week after a certain date. 4

Top