#1
|
|||
|
|||
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.
|
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
Yes if that's possible so when we changed the date to the pay period the date will automatically changed. If that makes sense.
|
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
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.
|
#8
|
||||
|
||||
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 |
#9
|
|||
|
|||
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.
|
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 |
help with formulate refers to values | meninio | Excel | 11 | 01-26-2011 10:00 AM |
Formulate month in Excel 2010 | meninio | Excel | 4 | 01-25-2011 12:13 PM |