excel formula help on Date

[Mallesh23]

Hello friends,

I am looking for date formula in excel, I want the date starting from Monday to Friday only .

I want to put the formula in A1. Drag till say till w1. Please suggest. Thanks.


Regards,
Mallesh

 

[Eric W]

First, this thread really should be in the Excel Questions forum.

Next, put your starting date in A1, then put this formula in B1 and drag to the right as far as needed.

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