| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help finding the date of the last Saturday of a given month
Hi,
I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
hi chuck try
=A1-WEEKDAY(A1) where A1 is the date -- _______________________ Naz, London "Chuck M" wrote: Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
Try this:
=DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,1)+n) Where n = 1 for Sunday ...........7 for Saturday Biff "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
sorry that should read
=eomonth(A1)-weekday(A1) -- _______________________ Naz, London "Naz" wrote: hi chuck try =A1-WEEKDAY(A1) where A1 is the date -- _______________________ Naz, London "Chuck M" wrote: Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
Try =DATE(2007,month+1,1)-WEEKDAY(2007,month+1,1)
-- David Biddulph "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
If you want something really long, try this:
=IF(WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5)))<7,DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))),DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))) The date you want the last Saturday of the month is in A1. "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
You missed a bit David
=DATE(2007,month+1,1)-WEEKDAY(DATE(2007,month+1,1)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Try =DATE(2007,month+1,1)-WEEKDAY(2007,month+1,1) -- David Biddulph "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
Yes, absolutely right, Bob.
-- David Biddulph "Bob Phillips" wrote in message ... You missed a bit David =DATE(2007,month+1,1)-WEEKDAY(DATE(2007,month+1,1)) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Try =DATE(2007,month+1,1)-WEEKDAY(2007,month+1,1) "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
Find the last Saturday of the month for any date:
=EOMONTH(a1,0)-CHOOSE(WEEKDAY(EOMONTH(a1,0)),1,2,3,4,5,6,0) Cell (A!) 5/11/07 05/31/07 =eomonth(a1,0) 5 =WEEKDAY(eomonth(a1,0)) CHOOSE(WEEKDAY(A1,0),1,2,3,4,5,6,0) 5/26/2007 = The Last Saturday =WEEKDAY(eomonth(a1,0)) Sunday(1) through Saturday(7) Sunday is 1 -1 = a Saturday Mon is a 2 -2 = a Saturday Tue is a 3 -3 = a Saturday Wed is a 4 -4 = a Saturday Thu is a 5 -5 = a Saturday Fri is a 6 -6 = a Saturday Sat is a 7 -0 = a Saturday "Chuck M" wrote: Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help finding the date of the last Saturday of a given month
Sorry for the delayed response. This is just what I needed. Thanks to all
who replied! -- Thanks. Chuck M. "Bob Phillips" wrote: You missed a bit David =DATE(2007,month+1,1)-WEEKDAY(DATE(2007,month+1,1)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Try =DATE(2007,month+1,1)-WEEKDAY(2007,month+1,1) -- David Biddulph "Chuck M" wrote in message ... Hi, I can't get my head around the calculation necessary to find the date of the last Saturday in any given month. Any help will be greatly appreciated! -- Thanks. Chuck M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
| Workday return a Saturday date | Setting up and Configuration of Excel | |||
| Finding the date on the 'nth' Monday in this Month in this Year | Excel Worksheet Functions | |||
| first saturday in a month | Excel Worksheet Functions | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
Linear Mode
