Auto date every Friday

  • Thread starter Thread starter csgannes
  • Start date Start date
C

csgannes

I submitt my work on Fridays. I know the code for the current date. I
there anyway I can have the date change to Fridays date. Eg. If on Mo
I open my spread sheet it should already have Fridays date and kee
that date all week until the following Mon when it will auto change t
the following Friday?. I 'll appreciate any help offered . Thank
:confused
 
Insert this formula where the Friday date should be: =TODAY
()+5-WEEKDAY(TODAY(),2)

There maybe better ways to do this.

The formula isn't intuitive but if you want an
explanation, try this: The Weekday function assigns
numbers to the days. When we use the syntax Weekday(x,2),
the 2 argument assigns 1 to Monday and 7 to Sunday. So, if
we open the spreadsheet on Monday (1), the formula adds 5
to the date, making next Saturday (6), then removes 1
since it is Monday, and winds up with Friday (5).

--John
 
Back
Top