General Question

  • Thread starter Thread starter brett4098
  • Start date Start date
B

brett4098

OK GUYS, THIS ONE WILL PROBABLY BE AS CLEAR AS MUD, BUT I'LL TRY. I HAV
AN INPUT SECTION OF MY SPREADSHEET THAT CONSISTS OF AN ARRIVAL DATE
DEPARTURE DATE, AND TOTAL TIME ON JOB. YOU GUYS ANSWERED MY EARLIE
QUESTION AND I THANK YOU. WHAT I WOULD LIKE TO DO NOW IS SAY FOR TH
MONTH OF JANUARY, CALCULATE THE DAYS ON A JOB USING THIS FORMUL
(=IF(AND(MONTH(F22)=1,YEAR(F22)=2004),H27,"")), WHERE H27 IS DAYS O
JOB FOR THE CURRENT MONTH. THE PROBLEM COMES IN WHEN THE MONTH CHANGE
TO FEBRUARY, I STILL WANT MY JANUARY DAYS TO STAY IN THE PREVIOUS CELL
BUT WANT TO CALCULATE DAYS FOR FEB. WHAT SHOULD I PUT IN THE "" ABOVE
GET IT OR IS IT NOT CLEAR? THANKS
 
Brett -
I would opt for taking the current date and subtracting the start date
to arrive at the total number of days on the job, then subtract out
the number of days worked on the job in January to get the remaining
days which would be those worked in February.
- Fred
 
Back
Top