Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

EOWEEK --- similar to EOMONTH

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jonathan Horvath - 16 Nov 2006 16:45 GMT
Hi,

   I know there isn't and EOWEEK function, but there should be :)

   I get lots of requests each day and want to run them through reports
showing incoming per week, etc...

   So I would like to find an equation that would look at the request date
and then tell me it was requested in the week ending "X".

   For example:

Req Date = 11/13/06    week end date = 11/17/06
Req Date = 11/1/06    week end date = 11/3/06
Req Date = 11/27/06    week end date = 12/1/06

etc...

Thanks!

Jon
Ron Coderre - 16 Nov 2006 16:57 GMT
Try something like this:

With
A1: (a date)

This formula returns  the Friday day of the week containing A1
B1: =A1-WEEKDAY(A1,2)+5
Weeks run  Monday thru Sunday

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon
David Biddulph - 16 Nov 2006 17:01 GMT
=A1+6-WEEKDAY(A1)
Signature

David Biddulph

> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon
Jonathan Horvath - 16 Nov 2006 18:01 GMT
Thanks guys, both solutions work...

Jonathan

> Hi,
>
[quoted text clipped - 17 lines]
>
> Jon
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.