Date criteria

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:24 PM GMT


I am making a School Course Catalog for my job. I need to make a table for the class dates. Some classes are the 2nd Tuesday of every month for a fiscal year. Is there a formula I can use inthat will populate the dates for me so I don't have to manually enter every date?


Give this a try. Put month dates (1/1, 2/1, 3/1, etc., can be any day of the month) in a column (in this example starting in cell A2), and put this formula in cell B2 and then copy it down:


This formula calculates the last Tuesday of the previous month and then adds 14 days to get the second Tuesday of the specified month.


©2018 eLuminary LLC. All rights reserved.