Forum Discussion
Solved
print in the middle section of header month, year of a cell
I have A1 with date 5/25/2018 >> upper(text(A1,"mmm")) &", " & text(A1,"yyyy") would give MAY, 2018 - how do I put this in the middle section of the HEADER for printing purposes? or add this to...
Can you change the sheet name to "May, 2018" and then insert sheet name in the header? The procedure may take time but it is is a way without using vba,.
Can you change the sheet name to "May, 2018" and then insert sheet name in the header? The procedure may take time but it is is a way without using vba,.
Mr. Chan
I think that is a fantastic way of doing it!!
MANY MANY THANKS
