+ Reply to Thread
Results 1 to 3 of 3

return week-ending date

Hybrid View

  1. 03-16-2005, 11:01 AM #1
    peacelittleone
    peacelittleone is offline
    Registered User
    Join Date
    03-10-2005
    Location
    East Greenbush, NY
    Posts
    26

    Question return week-ending date

    I have Column A which has a series of dates - non-unique.
    In Column B I need to have the week-ending date.

    For example -

    03/08/05 03/13/05
    03/08/05 03/13/05
    03/15/05 03/20/05
    03/15/05 03/20/05
    03/16/05 03/20/05
    03/17/05 03/20/05
    03/17/05 03/20/05
    03/17/05 03/20/05

    and so on.

    Any help is appreciated.

    Heather

    Heather Linsk
    h l i n s k @ g m a i l . c o m
    Reply With QuoteRegister To Reply
  2. 03-16-2005, 12:57 PM #2
    Alex Delamain
    Alex Delamain is offline
    Registered User
    Join Date
    07-01-2004
    Location
    Kent, UK
    Posts
    74
    =E15+(7-WEEKDAY(E15-1))

    will return the date of the following sunday. (If the date in question is a sunday then it will return that date)
    Reply With QuoteRegister To Reply
  3. 03-16-2005, 01:38 PM #3
    peacelittleone
    peacelittleone is offline
    Registered User
    Join Date
    03-10-2005
    Location
    East Greenbush, NY
    Posts
    26

    Thumbs up

    Thanks Alex! That was perfect!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1