Excel date question

P

pooljunkie912

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top