View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default 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.