I ibeetb Aug 15, 2003 #1 I would like to devise a formula to calculate the last saturday of the week that may have just passed- of any given week.... Any ideas?
I would like to devise a formula to calculate the last saturday of the week that may have just passed- of any given week.... Any ideas?
I ibeetb Aug 15, 2003 #2 By the way, as another example: If today is Tuesday, I need to calulate the date of the last Saturday......
By the way, as another example: If today is Tuesday, I need to calulate the date of the last Saturday......
C Chip Pearson Aug 15, 2003 #3 What should the formula return if the give date is a Saturday? The same day, or one week earlier? For one week earlier, use =A1-WEEKDAY(A1) For the same day, use =A1-WEEKDAY(A1)+7*(WEEKDAY(A1)=7) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
What should the formula return if the give date is a Saturday? The same day, or one week earlier? For one week earlier, use =A1-WEEKDAY(A1) For the same day, use =A1-WEEKDAY(A1)+7*(WEEKDAY(A1)=7) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
D Daniel.M Aug 15, 2003 #4 ibeetb, Also, for the same day (so finding current/previous Saturday): =A1-WEEKDAY(A1+1)+1 Regards, Daniel M.
ibeetb, Also, for the same day (so finding current/previous Saturday): =A1-WEEKDAY(A1+1)+1 Regards, Daniel M.
