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