Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2016, 09:09 PM
crussell crussell is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Novice
how do you formulate the date by pay period ending?
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default how do you formulate the date by pay period ending?

Can you please help me? I have this timesheet (see attached) everything is formulated but the date. I am trying to figure out how to enter a formula to calculate the bi-weekly pay-period in excel. For example: Pay period begins on 2/1/16 and ends on 2/15/16 then it starts again 2/16/16 then ends on 2/29/16. What I would like to happen is when the pay period begins on a different day of the week instead of a first day of the week it will automatically enter the date on the day. Then if possible the date can be at max meaning whatever the pay period ended the date should not continue on the next day. I'm not sure if I am making sense.
Attached Files
File Type: xlsx Timesheet.xlsx (16.6 KB, 18 views)
Reply With Quote
  #2  
Old 02-18-2016, 12:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
could you explain a bit more please; i don't quite understand your requirements?

BTW using merged cells is not a good idea, they are nothing but trouble
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-18-2016, 06:41 AM
crussell crussell is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Novice
how do you formulate the date by pay period ending?
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

Hello: Thank you for responding. How can I input a formula on the date from the beginning of the pay period to the end. Then it starts again on the day of the beginning of the pay period. Please ignore the date on the excel now. I was trying to play with it but I'm not going any where with the formula. So 2/16/2016 starts on Tuesday then 2/29/2016 ends on Monday. However with the rest of the days it will just be blank.

I don't think my excel is in merged cells?
Reply With Quote
  #4  
Old 02-18-2016, 08:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

And you want to fill in all days between the start and end day of the pay period?

In the file you posted there are merged cells.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 02-18-2016, 10:58 AM
crussell crussell is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Novice
how do you formulate the date by pay period ending?
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

Yes if that's possible so when we changed the date to the pay period the date will automatically changed. If that makes sense.
Reply With Quote
  #6  
Old 02-19-2016, 12:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I you have a date in A1, say then the next day is =A1+1, etc...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #7  
Old 02-19-2016, 07:00 AM
crussell crussell is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Novice
how do you formulate the date by pay period ending?
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

Yup that's how at first we had it but we would like the pay period begins on the day it starts then it formulates at due max at the end of the pay period. When we enter the date on the Period Ending it would just automatically enters the date. I'm not sure if I'm making sense.
Reply With Quote
  #8  
Old 02-19-2016, 09:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I'm sorry, I don't understand what you are trying to do.
Perhaps someone else will be better suited.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #9  
Old 02-23-2016, 07:38 AM
gebobs gebobs is offline how do you formulate the date by pay period ending? Windows 7 64bit how do you formulate the date by pay period ending? Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I'll take a quick stab at it. See attached. The dates all come from the field at the top which I changed to "Period Start". So whatever date you put there, that will be the date on the first row, regardless of what day of the week it is. I've only waded into the thread so if that's not what you want, perhaps it will at least help us understand what it is you do want.
Attached Files
File Type: xlsx Timesheet2.xlsx (17.4 KB, 11 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count the common time period (month) between two date period of time Barni Excel 6 08-15-2014 07:52 AM
Paragraph ending in following page tadlomc Word 1 01-18-2012 05:31 AM
Help on the formulate hours meninio Excel 2 02-11-2011 04:56 AM
how do you formulate the date by pay period ending? help with formulate refers to values meninio Excel 11 01-26-2011 10:00 AM
how do you formulate the date by pay period ending? Formulate month in Excel 2010 meninio Excel 4 01-25-2011 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft