View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Beginning of Pay Period for Bi-Weekly Timesheet

"Don" wrote in message
...

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


with @tiscali.co.uk


"Don" wrote in message
...
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.