I have two sheets both with a name column and a dates column. The 2nd sheet has months listed for all of 2011. The 1st sheet has months listed in 2011 (that illustrate what month a certain action occured for a certain employee, employees may have more actions one month than the next). ((Essentially what I am trying to do is put all this data into access run a query that links the name and months so all the data is tallied per month.))
Now the problem I am having is on sheet 1 I have a custom date format (ex. 2011-01) so it can match the format in sheet 2. the only problem is for sheet one I orginally got the dates in (ex. 01/19/2011) format. Even though I entered a custom format so it appears that the dates match, Access still reads in the original format thus I cannot link all my corresponding data. I have tried copying and pasting just the values and basically everything possible. I attached an example below to make it much simpler to understand, if you look at a date in sheet 1 it appears (2011-01) but if you click on the date in the forumla bar it appears (01/19/2011). I need the formula bar to also appear (2011-01). I feel like this should not be that hard but it has stumped me, thank you for all help in advance!
Bookmarks