Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?
Whatever you're trying to do, here is the formula, assuming you're starting in A1: Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008) Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008) In C1 put B1-A1 and that will give you the number of days between those two dates.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!
Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).
1) Make sure each column in your spreadsheet has a heading.
2) Highlight (select) the column of birthdays.
3) Choose Format from the menu bar.
4) Choose Cells... from the drop-down menu.
5) For the "category", choose Custom.
6) In the "type" box, type yyyy
7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.
8) Now, highlight the entire table
9) Then, choose Data from the menu bar
10) Choose Subtotals... from the drop-down menu
11) In the "At each change in" box, choose the name of the column with the birth dates
12) In the "Use function" box, choose Count
13) Leave all other choices at their defaults
14) Click OK, and you are done.
Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.
With VBA, you can write code to "loop" through that range of cells (A2:A500) and keep a count when the date is in March. With each iteration of your loop, test the value in the cell. Do the same for the other column. If this is not clear or I've misunderstood, please post back and we'll work on it more...
use the below formula to get the date of the LWD (Monday thru Friday) of the month. Assumed that if the date in cell A1 is 6-May-2005. then formula will be
highlite the cells you want. right click the mouse. go to format. select text in the first coloumn.
highlite the cells you want for the second column, right click the mouse and go to format and select number and no decimal.
Here is one way to do it: 1. In column A enter the name 2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.) 3. In column C put 31-12-2008 (December 31, 2008, the last day of the year) 4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13) 5. In column E, put this formula: (D2/30)*1.25 (assuming this is line 2) You can then copy these lines as many times as you need to, total them, etc.
Hi, Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.
First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.
Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970 The next cell down has a value of ='DataRecord'!B971 and so and on until B974
My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.
Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.
All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity. The graphs are automatically updated with the data each time the macro is run.
You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to. Hope this helps. Glad to be of assistance - please rate the solution I can learn from you. Thanks