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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Starting work period on a Saturday and ending on a friday | Excel Discussion (Misc queries) |