UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Insert Every Other Sunday's Date, Office 2013    
 
   
krosal
post May 10 2019, 10:20 AM
Post#1



Posts: 29
Joined: 22-October 18



Hello,
I have an excel spreadsheet that is used at the company I work for which employees enter there work day hours in.

Every 2 weeks, each employee is required to enter the date for the current pay period. The dates for pay period is every 2 weeks starting on the Sunday and ending on the Saturday 2 weeks later.

Every (2) weeks, all the users must figure out the start date for the current pay period.

Is there a formula that could be used for this to have that date entered automatically?

Please see the attached.

Thank you!

Kelly
Attached File(s)
Attached File  Pay_Sheet_Dates.zip ( 15.4K )Number of downloads: 0
 
Go to the top of the page
 
Minty
post May 10 2019, 10:59 AM
Post#2



Posts: 309
Joined: 5-July 16
From: UK - Wiltshire


As long as you have the starting date simply add 13 days to it to get the end date?

Go to the top of the page
 
krosal
post May 10 2019, 12:55 PM
Post#3



Posts: 29
Joined: 22-October 18



Hello,
Yes, that we currently have. I guess I have to rethink what I'm asking for.

Our pay current pay period is 04/28/2019 to 05/11/2019 which is a 2 week interval. So the next pay period would be 05/12/2019 to 05/25/2019 and so on. I guess this is getting to be more of a challenge that I first thought.

The Pay Dates are every (2) weeks, Sunday to Saturday, and for the date section that I have the question on is only for the first date, the second date is calculated from the first date.

The other question would be, is there is a way to lock the date in once the user starts entering their time?

Please see the attached document
This post has been edited by krosal: May 10 2019, 01:00 PM
Attached File(s)
Attached File  paysheet_1.zip ( 19.37K )Number of downloads: 0
Attached File  Capture.JPG ( 19.37K )Number of downloads: 0
 
Go to the top of the page
 
krosal
post May 10 2019, 02:43 PM
Post#4



Posts: 29
Joined: 22-October 18



The problem is we have to always figure out what the start date is. Many people have it wrong half the time.
Go to the top of the page
 
krosal
post May 10 2019, 05:40 PM
Post#5



Posts: 29
Joined: 22-October 18



I think I figured it out from a formula and I'm thinking that making the cell a drop down selection may be what I'll do.

=DATE(2019,1,1+((2-(1>=WEEKDAY(DATE(2019,1,1))))*7)+(1-WEEKDAY(DATE(2019,1,1))))

=DATE(2019,1,1+((4-(1>=WEEKDAY(DATE(2019,1,1))))*7)+(1-WEEKDAY(DATE(2019,1,1))))

If I keep going through the months, this gives me the correct dates that I need.

I guess I could just create the drop down based on this formula.

Unless someone has another recommendation.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th June 2019 - 12:28 PM