Hi,

yes its giving me e.g. a MM/YYYY date in column 3 if I enter such a date in column 2, 3 having your formula in., and yes I would drag it down to all rows.
I have as said subject1 date1, subject2 date 2 and so on along a row, one row per roll of film, makes sens to have a row per film as I have 400 or more rolls so downwards is the direction for such !
How would you have designed it ?


If I hide the column then as I need to type the date such as MM/YYYY into column 2 for your formula in column 3 to feed on it and show a MM/YYYY type date, I wont be able to type the date in. It needs to be visible, though one could say after entering subject hit tab which goes to column 2 and type date but I dont always have a date immediate available to enter, so that would mean clicking after the text then hit tab, its doable if I am careful.
Would that work ?
With all this obviously its saying that Excel doesnt have a format that accepts entry of YYYY or MM/YYYY or DD/MM/YYYY and displays as such. I am sure there are many folk frustrated by the fact that one must always know the full date for each entry.


DBenz