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!
Bookmarks