RETAILREALM
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
debug.print dateadd("d", 1-datepart("w", now), now)
debug.print dateadd("d", 8-datepart("w", now), now)