calculate weekdays only

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

You can do this with formula or code. Which one is
necessary for your application?
 
I prefer to do it with code. Is there also an Excel function that does this
I am unaware of?
 
dtDate = Range(A1)-1-choose(Weekday(Range(A1).Value)-1,2,0,0,0,0,0,1)
 
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

Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
convert spreadsheet formula into VBA formula 1
problem with date formula 5
Next weekday ... 3
Calculate Payment Days and Date 3
Weekdays 5
Date formats change (code included) 9
Not weekday 3

Back
Top