Reply to thread

Message: [QUOTE="pooljunkie912, post: 7406407"] Hi! I need help displaying dates in excel. I want to be able to write in day of the month (the 15th for example) and have excel automaticall change that to the 15th of current month we are in, and display it i month/day/year format. So I would like to somehow indicate to a cell that I want it to displa the 15th of the current month. So if it was july, I would want it t display 7/15/12. Once it becomes August, I want excel to automaticall change that date to display 8/15/12. Is there an easy way to do this? Thank you in advance for your help [/QUOTE]