Variable Date Selection
Variable Date Selection
(OP)
I am trying to setup a timesheet but don't want to rename the appropriate days of the week every week I start a new one. I simply want a template that adjusts the days of the week for the current week I am in.
What I want to do is have some sort of function that generates dates for the current week (some sort of a "Today() + X" where X is a variable function that fixes the dates for that given week).
Anybody know how?
Thanks
What I want to do is have some sort of function that generates dates for the current week (some sort of a "Today() + X" where X is a variable function that fixes the dates for that given week).
Anybody know how?
Thanks





RE: Variable Date Selection
TTFN
RE: Variable Date Selection
=day(today()) will return a value from 0 to 6 corresponding to Sunday to Saturday, which would seem a good start.
RE: Variable Date Selection
=WEEKDAY(TODAY()) returns 1 to 7
This litte formula:
=INT((NOW()-1)/7)*7+1
returns the previous Sunday. (Thanks to tek-tips)