Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make Exec work properly (error messages on start and exit) | Excel Discussion (Misc queries) | |||
4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |