Thanks for this but alas i dont get the Date in the required format
This is what i need to show in the cell Monday,28-05-2012
With the solution you gave me all i get is 28/05/2012
can some one please post as to how to enter the date in the following format:
Format: Monday,28-05-2012.
have tried all the formulas in the date menu and not one of those will give me the required format.
thanks
peter
have posted my workbook on google for any one to assist me with my search for an easy answer as i am stuck badly trying to figure out how to appy VLOOKUP to the second to last page of the workbook, the information needed for the vlookup is on the last page and i have added the cells where i need...
Howdy doody all, new here and hope to be able to get some help with learning Excel am from australia and am retired and am happy to take up a new hobby,