Seamus2626
asked on
Assess Date
Hi,
I need some formula to work out whether a data is this week or last week
So if date Serial is within last 7 days "this week"
if date serial is between 7-14 days old, last week
Maybe theres a smarter way?
Basically i have a string of dates and im trying to work out whether its this week or last week
Thanks
I need some formula to work out whether a data is this week or last week
So if date Serial is within last 7 days "this week"
if date serial is between 7-14 days old, last week
Maybe theres a smarter way?
Basically i have a string of dates and im trying to work out whether its this week or last week
Thanks
ASKER
I would prefer formula GlenN, but can work fine with VBA....
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Glenn!
You're welcome.
But, if you're looking at a Sunday - Saturday calendar, and the current Day is a Sunday, then any value <=7 is "Last Week". And that formula would change if you were on a Monday - Sunday calendar.
Do you need a formula in Excel or VBA?
-Glenn