Hi everyone
Slightly strange question here. I need to put dates along the top of a spreadsheet, Cells A1:IV1. I could simply input the starting date in cell A1, then drag the forumla across to IV1. However, I somehow need Excel to NOT list weekends or public holidays.
Does anyone know if this is possible, and if so, how to do it?
Thanks
James
Slightly strange question here. I need to put dates along the top of a spreadsheet, Cells A1:IV1. I could simply input the starting date in cell A1, then drag the forumla across to IV1. However, I somehow need Excel to NOT list weekends or public holidays.
Does anyone know if this is possible, and if so, how to do it?
Thanks
James