Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Consolidating Weeks
- Thread starter surad
- Start date
BobJacksonNCI
Technical User
If you're looking for the work week,
datepart("ww", date())
But it returns 38 today...
HTH,
Bob
Thread181-473997 provides information regarding this site.
datepart("ww", date())
But it returns 38 today...
HTH,
Bob
Thread181-473997 provides information regarding this site.
- Thread starter
- #3
Bob,
I am sorry I didn't clearly indicated what I was looking for. I am actually that function that returns the date(day) of particular week for example Second week of January 2003 ends Sunday the 12th therefore, I am looking the function that returns the 12th.
Thank you,
Yuri
I am sorry I didn't clearly indicated what I was looking for. I am actually that function that returns the date(day) of particular week for example Second week of January 2003 ends Sunday the 12th therefore, I am looking the function that returns the 12th.
Thank you,
Yuri
BobJacksonNCI
Technical User
Yuri,
Given a date, to calculate the last day of that week:
=Date() - WeekDay(Date(), 0) + 1
If you're starting with a work week, I don't know how to get there.
Maybe someone else can assist...
Good Luck!
Bob
Given a date, to calculate the last day of that week:
=Date() - WeekDay(Date(), 0) + 1
If you're starting with a work week, I don't know how to get there.
Maybe someone else can assist...
Good Luck!
Bob
- Status
Similar threads