convert weekday date to the next sunday date

O

Oldersox

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

Formula to tell day of week 3
Using a Date and corresponding weekday to pull amounts 1
Count 1
Calculating Turn Around Times excluding Sunday 1
How to calculate difference between two date & time along with working hours and days 2
Determining the Sunday date of the third "full" weekend of a month 26
Finding the right function & formula 4
Sumif weekday 3

Top