Date formula excluding 1 day

A

art

Hello:

I'm looking for a formula that would reflect the following:
saterday - thursday.
Should only reflect days from above but skip
friday when drag/drop through the column.
 
M

Mike H

Hi,

Put your start date in (say) A1 and this in A2 and drag down

=IF(WEEKDAY(A1)+1<>5,A1+1,A1+2)

Mike
 
A

art

Thanks, just needed to change one small part,
=IF(WEEKDAY(A1,2)+1<>5,A1+1,A1+2) otherwise it would skip thursdays not
fridays. Thanks anyways.
 
Top