Date formula excluding 1 day

  • Thread starter Thread starter art
  • Start date Start date
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.
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formula Excluding Weekends 3
Formula for adding a day to a particular date. 1
Exclude Weekends 4
Easy question (just not for me) 2
Reference the higest value 2
Comparison Formula 5
Week Ending data 2
Trailing 30 days sum calculation with excel 1

Back
Top