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") what I have been trying. It is giving me a value of false when it should be true in this instance.


thank you

Posted by cpod on February 22, 2001 1:51 PM

Try this:


Posted by Mark W. on February 22, 2001 3:26 PM

...Or this