hi all, i would like a cell to automatically return a month from another cell containing a date
e.g
1 cell 11/5/2005 the cell then returning text MAY and no other data e.g 11 or 2005 as other cells are counting this particular data with other cells so a format cell option would be no good
any ideas ?
e.g
1 cell 11/5/2005 the cell then returning text MAY and no other data e.g 11 or 2005 as other cells are counting this particular data with other cells so a format cell option would be no good
any ideas ?