I have a column of dates in chronological order spanning 3 years, however not every day - i.e. 7 july 1998, 13 july 1998 etc....
What I need to do is assign a numerical value to each of these dates. For example the first date in the series is "1"....the last "701". Apparently Excel stores the data for dates as a number but it wont let me change the display to show it simply as one number which refers to what day it was. Can anyone help?
Insert an empty column next to your date. Hard code the number "1" in the first row. Then hold down the Control key, hover your mouse over the bottom right corner of the cell with 1 in it, then drag down all the way to the bottom.
You'll most likely pull down too far, but just click in the cell with first number that is past your data, hold Shift + Control + (Down Arrow) and that will highlight all the extras so you can delete them.