Stephan
Member
1st Date of Year using Tab Ref, not Cell Ref?
For example in Tab TOTAL Cell BF2:
=DATE(YEAR(BG2),1,1)
Hence how to substitute BG2 with TAB YEAR: 2020?
The cause reason is to automate Years Tabs Cell X39, which currently is manually edited date.
Cheers
For example in Tab TOTAL Cell BF2:
=DATE(YEAR(BG2),1,1)
Hence how to substitute BG2 with TAB YEAR: 2020?
The cause reason is to automate Years Tabs Cell X39, which currently is manually edited date.
Cheers