+ Reply to Thread
Results 1 to 25 of 25

How many days left in the current month

Hybrid View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    nj
    MS-Off Ver
    excel 2007
    Posts
    68

    Re: How many days left in the current month

    hmm... yes, that works.... now I find that I can't make what I want to happen...happen.

    Ideally, what I'd like to happen is this:

    we are open monday thru saturday. I'd like to be able to automatically calculate how many work days there are in a month, first of all... and then how many remain from 'today'.... I could just use 27, as it is usually the right answer... but my inner nerd wants that to be precise.

    IF i can get that expressed as a simple 2digit number, I'd like for it to figure out, from the position of TODAY, how many 'open' days remain in the current month.

    for example, if I open the sheet on the 13 of November, I'd like it to be able to tell me how many days, counting only monday-saturdays remain, counting the present day.

    once I get that set, I'll want to be able to adjust that to the salesmen's schedules .... and they are off one of the open days each, and days off vary.

    anyone done this kind of thing before?
    Last edited by lumberjim; 11-09-2012 at 12:43 AM.
    self taught and painfully ignorant

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1