Hi
Is there a way to auto populate cells with a date based on the year entered in another.
In the frotpage sheet i enter 2021 in B6 and then i would like B6 in the January-2021 sheet to auto populate with the date 01-01-2021.
And based on B6 in the January-2021 sheet i would like B6 in February-2021 to auto populate with the date 01-02-2021.
Is there a way to auto populate cells with a date based on the year entered in another.
In the frotpage sheet i enter 2021 in B6 and then i would like B6 in the January-2021 sheet to auto populate with the date 01-01-2021.
And based on B6 in the January-2021 sheet i would like B6 in February-2021 to auto populate with the date 01-02-2021.