dalymjl

Junior Member

Location: Ireland

Posts: 29

Quote:

Originally Posted by daddylonglegs

Just replace YEAR(A1) in your formula with A1 - also the IF function is
redundant so this suffices

=MONTH(DATE(A1,2,29))=2

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503560

Excellent!! Thanks very much.

regards

mjd

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
Return the day of week for 1 January	dalymjl	About this forum	0	January 20th 06 08:17 PM
Macro to copy cells to rows below	[email protected]	Excel Discussion (Misc queries)	1	January 20th 06 06:59 PM
Macro to insert copied cells	[email protected]	Excel Discussion (Misc queries)	17	January 18th 06 10:40 AM
Return Sundays date of current week	durex	Excel Worksheet Functions	1	October 13th 05 04:37 PM
user defined function	Brian Rogge	Excel Worksheet Functions	5	May 23rd 05 06:21 PM

All times are GMT +1. The time now is 08:13 PM.

About Us

"It's about Microsoft Excel"