Results 1 to 3 of 3

Thread: Need week ending date formula

  1. #1

    Need week ending date formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am making a spreadsheet of our employees with the job they worked, dates they worked, etc... What I would like to do is when I put in the date they worked, I want another column to automatically put the week ending date. So, say an employee worked 9/17/13 (a Tuesday) - the week ending column would display 9/21/13 (a Saturday) - since our weeks are Sunday thru Saturday. Is this possible?

  2. #2
    =$a1-weekday($a1,2)+6

  3. #3
    Good answer, to complement a little the explanation, with the WEEKDAY() function you can find the number of the day of the week. It has 2 parameteres:

    The first one is the serial_number, here you choose the cell where is the date.
    The second one is the return_type, is a number:

    For Sunday=1 through Saturday=7 use 1
    For Monday=1 through Sunday=7 use 2
    For Monday=0 through Sunday=6 use 3

    Microsoft Excel Massive Open Online Course - myexceltutorial dot com
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Posting Permissions

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