LyndieBee

Posts: n/a

Date in an IF statement

I'd like to be able to evaluate the current date and have the name of the
previous month display in a cell. For example if I'm in cell A1 I want the
statement to check today's date (March 8, 2005) and return last month's month
"April". Can I accomplish this with an IF statement? Any other function?
Many thanks, Lyndie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date related IF statement	Miss Candace	Excel Worksheet Functions	1	February 28th 05 06:22 PM
Date related IF statement	Miss Candace	Excel Worksheet Functions	1	February 28th 05 04:32 PM
date and time	ladimples247	New Users to Excel	2	February 16th 05 08:52 PM
Need help troubleshooting an array formula XLXP on Win2K	KR	Excel Worksheet Functions	1	December 13th 04 07:41 PM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 04:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us