Excel Macro Weekday / Today Function

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
 
T

Tom Ogilvy

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.
 
Top