Results 1 to 6 of 6

Date picker to update overtime spreadsheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-28-2007
    MS-Off Ver
    2019
    Posts
    204

    How to change dates in a spreadsheet according to months

    Guy's
    I've got this spreadsheet that i need to change. Our timesheets now need to go from the 1st to the last day of the month (30th,31st etc) How get the dates in rows b to change according to the month in I4 and show only the 1st to last days of that month.

    Also this may be a little more complicated , How do i get the spreadsheet to automatically work out time&half hours and double time(sunday) hours. Obviously the positions will change depending on the month.

    thanks for you help.
    Last edited by jsmity; 01-03-2008 at 11:04 AM. Reason: didnt make sense

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