MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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")