Results 1 to 3 of 3

Semi Monthly Timesheet, need help with formulas

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2008
    Location
    California
    Posts
    2

    Semi Monthly Timesheet, need help with formulas

    I am hoping someone out there can make heads or tails of my problem.

    Here is the scenario and the outcome. Our accounting department wanted an Excel timesheet created that would be Sunday thru Saturday. They also wanted it where the "employee" could put in the pay period start date and have the timesheet correctly display the dates and days on the sheet. I thought I had it correctly but after testing it through 2009 I ran into a problem. I am using the forumla =S3-WEEKDAY(S3,2) for the first day of the payweek to show (Sunday). The rest follow by using =IF(E8=0,"",E8+1). S3 is my date input field. The E8 changes from each cell to the next to reference the one to the side of it.

    Now the problem I have is if I put in any date where the 1st falls on a Sunday it will add one full week prior to the week starting.

    Please look at the attached worksheet and try the following dats.
    12/01/2008
    01/01/2009
    02/01/2009

    Pay attention to the first Sunday listed and what happends when you go to 02/01/2009.

    Thanks in advance for anyones help. I am sure it's just something I am not catching. I don't claim to be an expert in excel but this can't be that hard. I think I have been looking at it for too long now.

    Attached Files Attached Files

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