Calulating the last sayurday of a week using vba
I am trying to write a formula, using vba to give me the date of the last
saturday from 'Today's date'. For example, if today is Monday, what is the date of last saturday.... Any ideas? |
Calulating the last sayurday of a week using vba
Assume the date you're using as the start point is stored
in variable x, then: y = x - (weekday(x) + 1) will give you last Saturday's date in y, assuming you haven't changed the FirstDayofWeek constant from Sunday. Cheers, Pete -----Original Message----- I am trying to write a formula, using vba to give me the date of the last saturday from 'Today's date'. For example, if today is Monday, what is the date of last saturday.... Any ideas? . |
Calulating the last sayurday of a week using vba
Hi, Pete:
Your code as written gives ME the previous Friday, not Saturday. You don't want to add 1 here. i.e. it should be just y = x - Weekday(x) Myrna Larson On Fri, 15 Aug 2003 09:03:35 -0700, "Pete McCosh" wrote: Assume the date you're using as the start point is stored in variable x, then: y = x - (weekday(x) + 1) will give you last Saturday's date in y, assuming you haven't changed the FirstDayofWeek constant from Sunday. Cheers, Pete -----Original Message----- I am trying to write a formula, using vba to give me the date of the last saturday from 'Today's date'. For example, if today is Monday, what is the date of last saturday.... Any ideas? . |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com