Results 1 to 3 of 3

Formula to produce Sunday date

Threaded View

  1. #1
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    375

    Formula to produce Sunday date

    Hey all,

    I'm try to figure out a formula that will calculate Sunday's date of a given week based on a Monday-Sunday date in a different cell.

    EX. A1 - 5/12/11 result in A2 - 5/15/11
    A1 - 5/15/11 result in A2 - 5/15/11

    Any ideas?

    Thanks Gang!
    Last edited by scaffdog845; 05-12-2011 at 02:22 PM.
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1