Thread
:
Beginning of Pay Period for Bi-Weekly Timesheet
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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.
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann