Beginning of Pay Period for Bi-Weekly Timesheet

[Guest]

Hello,

I have been working on some different timesheets for the same company for
the last 4 months on and off. Basically I completed one, everyone loved it,
and now interns and work studies want their timesheets to do the same thing.
I have completed everything but one thing that I need help on. Plus, this is
more of a luxury than a necessity.

Based on a bi-weekly pay period, I need the Sunday before the first day (pay
period beginning) entered to automatically appear. A month ago someone told
me how to get the last Saturday of the second week (end of pay period) to do
this, so I thought it would be a simple switch MAX to MIN. Shows what I
know. So, if anyone could help, thank you ahead of time.

 

[Guest]

Damn, forgot to mention something. Make sure to embed the function in an IF
statement so the cell is blank when there are no dates entered.

 

[Bob Phillips]

=IF(A1="",A1-DAY(A1)-WEEKDAY(A1-DAY(A1),1)+1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Ok, was that supposed to work? Because it didn't.

 

[Sandy Mann]

Based on a bi-weekly pay period, I need the Sunday before the first day
(pay
period beginning) entered to automatically appear.

With the date you entered in B2 try:

=IF(B2="","",B2-WEEKDAY(B2)+1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Bob Phillips]

No it wasn't meant to work, I just thought I would throw it out for a laugh.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

That worked. I actually think I messed up the first time. I tried applying
the formula to all dates rather than the first day entered. Makes since that
someone would start with the top most cell. My brain was just a few steps
behind. Anyway, I am going to try bob's as well now that I am thinking
strait.