Auto populate date
Is there a way to autopopulate a date within a column, specifically the second Tuesday of every month?
Best Answer

There is no way to get it to autopopulate without a helper column containing dates. If you use two helper columns, we can get it put together with relatively little work.
First would be a text/number column (called "Number" in this example). You can enter 0 in the top row and 1 in the second row then highlight both cells, grab the bottom right corner, and dragfill as far down as you want to go (within sheet limits of course).
You will need to pick a starting year and month (indicated in bold below), but then you can use this formula in a date type column (called "Date" in this example) to populate the first of every month increasing in relation to the Number column.
=IFERROR(DATE(start_date_year + ROUNDDOWN((start_date_month + Number@row) / 12, 0) + IF(IF(MOD(start_date_month + Number@row, 12) = 0, 12, MOD(start_date_month + Number@row, 12)) = 12, 1)  IF(AND(ABS(Number@row)  start_date_month <> 12, Number@row < 0, ABS(Number@row) > start_date_month), 1, 0), IF(MOD(start_date_month + Number@row, 12) = 0, 12, MOD(start_date_month + Number@row, 12)), 1), DATE(IF(start_date_month  ABS(Number@row) < 1, start_date_year  1, start_date_year), IF(start_date_month  ABS(Number@row) < 1, start_date_month + (12  ABS(Number@row)), start_date_month  ABS(Number@row)), 1))
Then in the next date type column you would use this to output the second Tuesday of the month:
=DATE(YEAR(Date@row), MONTH(Date@row), 1) + (IF(WEEKDAY(DATE(YEAR(Date@row), MONTH(Date@row), 1)) <= 3, 3, 3 + 7)  WEEKDAY(DATE(YEAR(Date@row), MONTH(Date@row), 1))) + 7
EDIT TO UPDATE: Both of the formula above can be applied as column formulas
Answers

Can you explain this better?

There is no way to get it to autopopulate without a helper column containing dates. If you use two helper columns, we can get it put together with relatively little work.
First would be a text/number column (called "Number" in this example). You can enter 0 in the top row and 1 in the second row then highlight both cells, grab the bottom right corner, and dragfill as far down as you want to go (within sheet limits of course).
You will need to pick a starting year and month (indicated in bold below), but then you can use this formula in a date type column (called "Date" in this example) to populate the first of every month increasing in relation to the Number column.
=IFERROR(DATE(start_date_year + ROUNDDOWN((start_date_month + Number@row) / 12, 0) + IF(IF(MOD(start_date_month + Number@row, 12) = 0, 12, MOD(start_date_month + Number@row, 12)) = 12, 1)  IF(AND(ABS(Number@row)  start_date_month <> 12, Number@row < 0, ABS(Number@row) > start_date_month), 1, 0), IF(MOD(start_date_month + Number@row, 12) = 0, 12, MOD(start_date_month + Number@row, 12)), 1), DATE(IF(start_date_month  ABS(Number@row) < 1, start_date_year  1, start_date_year), IF(start_date_month  ABS(Number@row) < 1, start_date_month + (12  ABS(Number@row)), start_date_month  ABS(Number@row)), 1))
Then in the next date type column you would use this to output the second Tuesday of the month:
=DATE(YEAR(Date@row), MONTH(Date@row), 1) + (IF(WEEKDAY(DATE(YEAR(Date@row), MONTH(Date@row), 1)) <= 3, 3, 3 + 7)  WEEKDAY(DATE(YEAR(Date@row), MONTH(Date@row), 1))) + 7
EDIT TO UPDATE: Both of the formula above can be applied as column formulas
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 67 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!