mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
I HAVE A FORMULA THAT WILL GIVE ME THE PERCENTAGE OF PEOPLE THAT ENROLL INTO SCHOOL. IT'S BASED ON THE NUMBER OF INTERVIEWS, AND OUT OF THOSE INTERVIEWS, HOW MANY OF THOSE ENROLL.
THE SPREADSHEET STARTS ON 7/18/07 BECAUSE THAT IS WHEN I STARTED IT. SO, RIGHT NOW IT WILL SHOW ME THE TOTAL PERCENTAGE FROM 7/18 TILL THE DATE OF MY LAST INTERVIEW, BEING THAT I INTERVIEW PEOPLE EVERYDAY, IT WILL SHOW 7/18 TO TODAY(). WHAT FORMULA CAN I USE THAT WILL SHOW ME THE PERCENTAGE FROM WHATEVER DATE I WANT? FOR EXAMPLE:
A2 WILL HAVE THE DESIRED DATE, AND A3 WILL ALSO SHOW ANOTHER DATE. A4 WILL GIVE THE PERCENTAGE.
A2- 8/1/07
A3- 8/24/07
A4- %
THE SPREADSHEET STARTS ON 7/18/07 BECAUSE THAT IS WHEN I STARTED IT. SO, RIGHT NOW IT WILL SHOW ME THE TOTAL PERCENTAGE FROM 7/18 TILL THE DATE OF MY LAST INTERVIEW, BEING THAT I INTERVIEW PEOPLE EVERYDAY, IT WILL SHOW 7/18 TO TODAY(). WHAT FORMULA CAN I USE THAT WILL SHOW ME THE PERCENTAGE FROM WHATEVER DATE I WANT? FOR EXAMPLE:
A2 WILL HAVE THE DESIRED DATE, AND A3 WILL ALSO SHOW ANOTHER DATE. A4 WILL GIVE THE PERCENTAGE.
A2- 8/1/07
A3- 8/24/07
A4- %