hey all first time posting long time viewer. Thanks in advanced for your help. im having trouble making a formula that would generate a pay period for every day of the month ie..
a b
1/1/2006 1/16/2006
1/2/2006 1/16/2006
1/3/2006...
col a has the dates, and column b would have the pay period which is every other sunday any help and tips would be great or point me in the right direction. Ive seen many other posts about dates but not quite what im looking for thanks
not too sure i understand your requirement, but have you tried playing around with the =WEEKDAY("date",2) function? if this doesnt work, maybe upload a sample workbook that i can take a look at for you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks for the quick reply
payend.png
Not sure about your example why does 1/1/2006 show pay period as 1/15/2006 but 14 days later 1/15/2006 also shows 1/15/2006? Assuming you always show the next pay date try this formula assuming date in A1
=MOD(DATE(2006,1,1)-A1,14)+A1
Audere est facere
"1/1/2006" is the day worked and 1/15/2006 is the end payroll date so "1/1/2006" corresponds to "1/15/2006" since thats when the end of the pay period is, "1/2/2006-1/15/2006" all corresponds to "1/15/2006" for the end of the pay period
OK but if 1/15/2006 is the end of the period doesn't the previous period end 14 days before that on 1/1/2006, so I'm suggesting that you aren't consistent there.
Does my formula give the results you want?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks