mercmannick
04-18-2006, 09:57 AM
hi
i have this formula =WEEKNUM(TODAY(),1)
which i use to get weeknumber
which i then use this
=IF($I$2<10,$H$2&".0"&$I$2,$I$2&"."&$H$2)
where H2 has the year in "2006" and I2 has the formula above in.
to give me the date in this format 16.2006
i then use a vlookup on this date value being the lookup value from table array on another sheet
the problem i am getting is in the vlookup box it recognises as 16.2006 , but returns a #n/a , if i manually put date in it is fine
Any Suggestions ( and is there an easier way to get the date in the format i want)
Also Posted on http://www.mrexcel.com/board2/viewtopic.php?p=994580#994580
Regards
Merc
i have this formula =WEEKNUM(TODAY(),1)
which i use to get weeknumber
which i then use this
=IF($I$2<10,$H$2&".0"&$I$2,$I$2&"."&$H$2)
where H2 has the year in "2006" and I2 has the formula above in.
to give me the date in this format 16.2006
i then use a vlookup on this date value being the lookup value from table array on another sheet
the problem i am getting is in the vlookup box it recognises as 16.2006 , but returns a #n/a , if i manually put date in it is fine
Any Suggestions ( and is there an easier way to get the date in the format i want)
Also Posted on http://www.mrexcel.com/board2/viewtopic.php?p=994580#994580
Regards
Merc