Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to get this formula to start the work period on a saturday and
end on a friday (rather than the normal week of Sunday thru Saturday) ="Work Period "&TEXT(TODAY()-WEEKDAY(TODAY(),1)+1,"mmmm d")&" - "&TEXT(TODAY()-WEEKDAY(TODAY(),1)+14,"mmmm d, yyyy") As is it starts on Sunday and ends on saturday. I tried changing the +1 to a -1, but that didn't work. What do I need to change to make this happen? |