Link to home
Start Free TrialLog in
Avatar of RETAILREALM
RETAILREALMFlag for United States of America

asked on

Find week start date and weekend date from current date

If I select current date as  26/Apr/2006 it will give me  week start date
As  23/Apr/2006 and weekend date as 29/Apr/2006
Similarly
If I select current date as  31/May/2006 it will give me  week start date
As  28/May/2006 and weekend date as 03/Jun/2006
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Guy Hengel [angelIII / a3]
http://www.w3schools.com/vbscript/func_datepart.asp

debug.print dateadd("d", 1-datepart("w", now), now)
debug.print dateadd("d", 8-datepart("w", now), now)