If Cell=Date
Posted by Shazadi on February 22, 2001 1:40 PM
I need to retrieve information from another workbook from a #ofSales cell, ONLY IF the date on that workbook(entered in a seperate cell), is the month of January, then february and so on and so forth. I am try to compile a History of Data for the year but everything I seem to use doesn't work.
=IF([WESTWOODT.xls]blkform!$L$7=1/1/2001,[WESTWOODT.xls]Totals!$N$9,"N/A")
....is what I have been trying. It is giving me a value of false when it should be true in this instance.
HEEELLLLPPPPP!
thank you
Posted by cpod on February 22, 2001 1:51 PM
Try this:
=IF([WESTWOODT.xls]blkform!$L$7=datevalue("1/1/2001"),[WESTWOODT.xls]Totals!$N$9,"N/A")
Posted by Mark W. on February 22, 2001 3:26 PM
...Or this
=IF([WESTWOODT.xls]blkform!$L$7="1/1/2001"+0,[WESTWOODT.xls]Totals!$N$9,"N/A")
