If date in G2 is greater than date in C3 then make date in G2 same as date in C3

Good morning. I am working on a spreadsheet that tracks units used during each week of an authorization period. I have it set up to have a weekending date auto-fill based on dates in other cells. Currently, I have the spreadsheet set up for a 12 week authorization but I would like the dates to auto-fill only up to the last date of the authorization. I've tried nesting IF statements but can't get the wording correct. Here's what I'm attempting (in sentence format) to create in a formula:

IF date in G2 is equal to date in C3 then stop auto-populating dates in adjacent cell, IF date in G2 is greater than date in C3 then make date in G2 same as date in C3.

Thanks.

Matthew


Unit Tracking Sheet (blank).xlsm

Glenn,

Your suggested formula did the trick exactly as needed. Thanks for providing the suggestion. I've attached a copy of the spreadsheet (with new formula) below. Thanks again.

Unit Tracking Sheet (blank).xlsm

Glenn,

(red faced-embarrassed) You are correct. It was ChemistB who suggested the formula that worked. Thanks for pointing that out and for weighing in on my matter.

Matthew