+ Reply to Thread
Results 1 to 5 of 5

Automatically divide cell by days remaining in the week

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Automatically divide cell by days remaining in the week

    Hi!
    I am new to excell and need lots of help.
    I Need a formula that will divide cell b2 by the number of days left in the work week.
    I need the formula to change the day automatically.
    For example...when I open the worksheet on Monday I would like b2/5. When I open the worksheet on Tuesday b2/4, etc. Any help will be greatly appreciated.

  2. #2
    Registered User
    Join Date
    08-30-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Automatically divide cell by days remaining in the week

    Granny,

    The following formula will work for you. This will work regardless of it being a work day or week end.

    =B2/((TODAY()+6-MOD(WEEKDAY(TODAY())+7,7))-TODAY())

  3. #3
    Registered User
    Join Date
    09-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Automatically divide cell by days remaining in the week

    That's close but I need the formula to round up to the next full number

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Automatically divide cell by days remaining in the week

    Try
    =B2/ (7-MOD(TODAY(),7))

    or

    =ROUNDUP(B2/ (7-MOD(TODAY(),7)), 0)
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Registered User
    Join Date
    09-01-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Automatically divide cell by days remaining in the week

    Thank you that worked!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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