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()))
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()))