Work days left (Excel / Numbers)

Discussion in 'Mac Basics and Help' started by rasmusDoh, Apr 15, 2010.

  1. rasmusDoh macrumors regular

    Joined:
    Nov 30, 2009
    #1
    Hi there

    I wan't an app - or something like that - that can tell me how many work days that are left from today to an other specified date.

    I've Googled it, but i simply can't seem to find anything that can do this.
    I found a little app called Days Left, but that only works with the total amount of days and doesn't exclude weekends and holidays.

    I've succesfully made a spreadsheet in both Excel and Numbers (to check which was better) that can do this for me. With Quick Look it's almost like the little app that i wanted.

    The problem is, that (lazy as i am) i don't wan't to open up the spreadsheet every day, so Excel or Numbers can refresh the =Today() formula and thus give me the right date in Quick Look.


    Are there any ways i can have the spreadsheet update when Quick Look'ing it or in any other way without having to start up the program itself every time?
    If anyone actually knows of a little app that can, in fact, do these things for me, please let me know too!


    Thanks a bunch
     
  2. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #2
    System Preferences > Accounts > Login Items pane
    Click the + button, then navigate to your file and click Add.
    Now the computer will open the file each time you login to that account.

    Not the perfect App for what you want, but gets the job done with your custom made file.
     
  3. rasmusDoh thread starter macrumors regular

    Joined:
    Nov 30, 2009
    #3
    Thanks, but wouldn't that keep Excel open also at all times then (taking up memory)?
     
  4. Gregg2 macrumors 603

    Joined:
    May 22, 2008
    Location:
    Milwaukee, WI
    #4
    Yes, but do you get the "spinning beach ball" when running Excel along with other apps you commonly have open? If not, it's not taking up too much RAM.

    I'm not sure I understand the functionality. Do you have to update the date every day, or can you just open it on days you need the information?

    My suggestion will cause boot up to take longer, but not require you to remember to open the file. If you're concerned about RAM usage, then just Quit Excel.

    Sorry, I don't know of an app that will update an Excel formula without opening the file.
     
  5. ergdegdeg Moderator emeritus

    ergdegdeg

    Joined:
    Oct 13, 2007
    #5
    It's not exactly an app by itself, but you could use Wolfram Alpha to calculate the weekdays between two dates (e.g. here), create a webclip with safari and show that in your dashboard. It updates, whenever you go to the dashboard.
     
  6. rasmusDoh thread starter macrumors regular

    Joined:
    Nov 30, 2009
    #6
    That's actually pretty nice ergdegdeg.

    Thanks a lot!
     

Share This Page