Hi all,

I need a macro to auto-populate a cell (range C4:C13 on sheet "Template") based on the date criteria below. So if today's date < Date 1, then cell should auto-populate with "12/31/2018". If today's date is > date 1 and < date 2, then cell should auto-populate with "03/31/2019", and so on, following the same logic.

Today's date
3/26/2019 (cell C2)

Dates for GL
Date 1 -> 4/2/2019 (cell D2)
Date 2 -> 8/15/2019 (cell D3)
Date 3 -> 11/15/2019 (cell D4)
Date 4 -> 3/31/2019 (cell D5)

I put together a macro and added it to sheet 1 where my target range is, but for some reason it's not working. Can someone tell me what I'm doing wrong?

Please Login or Register  to view this content.
Thank you!