+ Reply to Thread
Results 1 to 5 of 5

Payroll Spreadsheet

  1. #1
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    126

    Payroll Spreadsheet

    ok guys I need your help.

    Im doing a spreadsheet for payroll.

    I want to be able to select a month and a year from 2 cells, then have the spreadsheet pull 21st of that month to the 20th of the next month and display them dates with the days of the week next to them.

    or a possiblity is that they extra cells be locked at the minute i cant seem to find a way of doing it.

    thanks in advance.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Try the attached macro
    Attached Files Attached Files
    Martin

  3. #3
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    126

    nearly there!

    works a treat,

    Just 1 thing febuary isnt working properly, listing to many days

    can see now by the macro i had no chance doing that on my own.

    is it possible to change it to account for feb,

    thanks alot Martin

    Simon

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Replace with this amended macro

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    09-21-2007
    Posts
    126

    thankyou

    thanks alot I really appreciate it,

    gonna make doing payroll a whole lot easier.

    Thanks again Martin

+ 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