Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JLyons
 
Posts: n/a
Default I really need help! Changing work period start dates

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()))
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Exec work properly (error messages on start and exit) TorG 8-(( Excel Discussion (Misc queries) 9 April 18th 06 01:10 PM
4 Day Work Week in a formula EasleyK Excel Discussion (Misc queries) 1 January 29th 05 06:15 AM
Sumproduct help needed! Trying to excel in life but need help Excel Worksheet Functions 5 January 21st 05 09:07 PM
Change Path names in copied work book jheaney Excel Worksheet Functions 2 November 18th 04 07:29 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"