count of week starting saturday from Apr

[amandeep08]

I want the count of week from Saturday to friday from 1st Apr'11 and 1st jun'11.

Is there any formula in excel which can calculate count of week till today's date.

 

[Yahya]

HI amandeep08
i think you can count the number of weeks which start Saturday by this formla

Excel Workbook
	A	B	C
1	01/04/2011		9
2	01/06/2011
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C1	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))=7))