Excel Macro Weekday / Today Function

  • Thread starter Thread starter QTE
  • Start date Start date
Q

QTE

Would like to increment a formatted General cell by 1 each time the da
is either Tuesday or Friday, from one year to the next. Would lik
this to be automated so that it is updated regardless of whether
actually open the file. So, if I have not opened the file for 2 week
the cell will be updated by the required days during those 2 weeks.

Thanks
QT
 
use a formula in the cell that counts the number of Tuesdays and Fridays
from whatever you start date is.

The meat of the formula would be something like (now - startdate)/7*2 then
dealing with the the start and end week.
 
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

Excel Macro Weekday / Today Function 5
Return the Date of a certain Day Each Month 2
Run macro by day --- but only once per day 4
week numbers 3
Weekly or Bi-weekly dates 4
Autofill today's date Everyday 2
Weekly or Bi-Weekly dates 2
How to code it in macro? 2

Back
Top