Results 1 to 11 of 11

Excel 2000 - show billable days

Threaded View

php4u Excel 2000 - show billable... 12-16-2008, 11:13 AM
EdMac try For the first ... 12-16-2008, 11:22 AM
royUK In I5, try ... 12-16-2008, 11:24 AM
php4u Excel 2000 billable days 12-16-2008, 04:37 PM
php4u Is there a way to hide the... 12-16-2008, 06:04 PM
EdMac OK In F5 ... 12-17-2008, 04:28 AM
  1. #1
    Registered User
    Join Date
    12-16-2008
    Location
    Northern California
    Posts
    6

    Excel 2000 - show billable days

    I have been asked to create a spreadsheet that will contain three fields;

    Date of placement (the day the person arrived)
    Date of release (the above + 60 days)
    Billable days for the current month

    The first is simple, the clerk will enter the current date when the person arrives.

    For the second field I am using:: =SUM(H5+(60),) (H5 is todays date, and will display the results in I5). When H5 is blank, I get the " #VALUE!" error in I5? Is there a more effective function to use?

    For billable days, I am using; =SUM(J2 - (H5),) (J2 is simply the last date of the month; 12/31/09, and H5 is the placement date). I want to show the number of billable days in the current month. This will be repeated on 12 sheets (one for each month).

    Any suggestions greatly appreciated,

    Thanks!
    Ralph
    Last edited by php4u; 12-17-2008 at 10:21 PM.

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