Looking for specific date formula
Posted by Beginner Bob on January 07, 2002 4:02 PM
I have several worksheets in my workbook where each sheet corresponds to a year (1999-2010). I'm looking to put a formula in cells B8:B59 that calls the 1st Tuesday of the year (from B8) to the last Tuesday of the year (to B59), hence the 52 rows. The year will be specified in cell B3, but I'm not sure of the function sequence (ie: weeknum, weekday functions) to use. Can someone help please? Thanks.