Results 1 to 7 of 7

Rounding Dates up to the 15th or the last day of the month

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2010
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Rounding Dates up to the 15th or the last day of the month

    I'm trying to identify a list of effective dates to the respective pay periods by using a rounding formula so for example, an effective date of 8/2/10 would be in the 8/15/10 pay period and 8/16/10 would be in the 8/31/10 pay period. Any help would be awesome!
    Last edited by karenbr; 10-11-2010 at 01:47 PM. Reason: Solved
    Karen

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