Date Formula - Only list working days, NOT weekends/holidays

[Start123]

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

 

[Gerald Higgins]

This will do Mondays to Fridays only, but will still show public holidays.
Input start date in A1.
Put this in B1, copy across, and format as date.

=IF(WEEKDAY(A1)=6,A1+3,A1+1)