I really need help! Changing work period start dates

J

JLyons

I gotsome help a while back creating the formulas to automatically input
correct and corresponding dates on the time sheet. Now the work period is two
weeks and runs from Saturday thru friday. The formula below gives me sunday
thru saturday. I need it to run saturday thru friday

="Week of "&TEXT(TODAY()-WEEKDAY(TODAY(),1)+1,"mmmm d")&" -
"&TEXT(TODAY()-WEEKDAY(TODAY(),1)+14,"mmmm d, yyyy")

And, I need for the following formula to change to start on saturday and end
on friday. Right now it starts on sunday and ends on saturday. I know that if
I change the "1" to "2" until I get to "14" it will give me the entire two
week period. I just need to know how to start the week on saturday.

=INT(NOW()+1-WEEKDAY(NOW()))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top