Date formula excluding 1 day
 

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.

Date formula excluding 1 day
 

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

"art" wrote:

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.

Date formula excluding 1 day
 

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.

"Mike H" wrote:

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

"art" wrote:

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.