Excel question involving dates
Happy Friday. I am having trouble recalling how I used to have Excel calculate the date. The fact pattern is ----> I put the "Now" function in one cell and then in another cell, I grabbed the month and year portion from the results of the Now function. All I want to do is display, for example, June 2008, in a designated cell automatically in real time. I would also like to be able to subtract 1 from the month if I am working on last month's data. Any thoughts? Thanks.
__________________
Liz Lemon's Mom on why she didn't pursue marriage to Buzz Aldrin: "It wasn't that simple, Liz. I had just graduated from secretarial school, and I got a job at Sterling Cooper."
|
05-30-2008, 12:27 PM
Threaded Mode