MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula and date problems


Posted by Judy on August 26, 2001 2:13 PM

Aladin
email me jcheuvront@adelphia.net

I did what you said, but no go!
I upgraded to SR-2 and I adjusted the formula.
I get a value error with the formula change, and all the info that is subject to transfer itself onto page 10, according to their date, is all going on one line (Jan-02) instead of the proper month. Can I email this workbook to you?

Original Message:


Posted by Aladin Akyurek on August 26, 2001 2:24 PM

> Can I email this workbook to you?

Yes. See the header for my address.

Aladin

Posted by Aladin Akyurek on August 26, 2001 4:55 PM


There is something with the mail system.

Anyway, one paren in the SUMPRODUCT formula was misplaced in the workbook, whence the trouble.

Aladin