Posted to microsoft.public.excel.worksheet.functions

Christopher Naveen[_2_] Christopher Naveen[_2_] is offline

external usenet poster

Posts: 58

Year & Month format

Hi,

I have col which contains year & month. Now i want to pull the values which
is less than or equal to current month.

A
2006-08
2008-04
2007-11
2008-01
2007-11

I tried with this formula but it is not working. Can any one help me?

=IF(year(a2)&"-"&MONTH(A2)<=year(TODAY()&"-"&month(today()),MONTH(TODAY())&"-"&YEAR(TODAY()),"")

- Christ

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
How do I set up and use Month day, year format with other appl?	[email protected]	Excel Discussion (Misc queries)	2	June 26th 06 10:51 PM
I need date format to be set up as month/year.	Aaron	New Users to Excel	2	December 22nd 05 01:46 PM
day/month/year in incorrect format for date format	M&A_Jack	Excel Worksheet Functions	2	August 16th 05 08:15 PM
month & year format in two digits	Morphyus C via OfficeKB.com	Excel Discussion (Misc queries)	1	August 5th 05 06:22 PM
Month Year Date Format	Jamie	Excel Worksheet Functions	2	February 7th 05 06:43 PM

All times are GMT +1. The time now is 11:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us