Date criteria

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

Question

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?

Answer

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:

=DATE(YEAR(B2),MONTH(B2),1)-MOD(DATE(YEAR(B2),MONTH(B2),1)-3,7)+14

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

Advertisement

©2017 eLuminary LLC. All rights reserved.