Hi
Please see the attached file where I am having date Monday to Saturday Except Sunday for 1 month and same pattern for each sheet name. Problem is that I am manually adding date on top and date at bottom for sheet name .
Query - Could please tell me how I can just write 1 time on sheet 1 for Ist of every month starting Monday and all other sheets get next date itself except Sunday and same for Sheet name? Hope you understand my query. Thanks
Please see the attached file where I am having date Monday to Saturday Except Sunday for 1 month and same pattern for each sheet name. Problem is that I am manually adding date on top and date at bottom for sheet name .
Query - Could please tell me how I can just write 1 time on sheet 1 for Ist of every month starting Monday and all other sheets get next date itself except Sunday and same for Sheet name? Hope you understand my query. Thanks