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.
--
Regards,
Tom Ogilvy
"QTE " wrote in message
...
Would like to increment a formatted General cell by 1 each time the day
is either Tuesday or Friday, from one year to the next. Would like
this to be automated so that it is updated regardless of whether I
actually open the file. So, if I have not opened the file for 2 weeks
the cell will be updated by the required days during those 2 weeks.
Thanks
QTE
---
Message posted from http://www.ExcelForum.com/