G
Guest
I use a form that includes lookup tables. one of the lookup tables contains
financial accounting dates, e.g.,week 1 on lu table is 01/03/05 and 01/07/05
then 7 day intervals thru week 52.
When I try to use "&" in combination with the lookup, I get the date
returned as a serial number. For example vlookup(week,weeknumber,2)&"thru
"vlookup(weeknumber,3).
The dates table was regular dates format, then copy/paste special/values.
What am I doing wrong?
financial accounting dates, e.g.,week 1 on lu table is 01/03/05 and 01/07/05
then 7 day intervals thru week 52.
When I try to use "&" in combination with the lookup, I get the date
returned as a serial number. For example vlookup(week,weeknumber,2)&"thru
"vlookup(weeknumber,3).
The dates table was regular dates format, then copy/paste special/values.
What am I doing wrong?