paste this formula into D2 and fill down
![]()
=IF(AND(DATEVALUE("01-" &B2&"-"&A2)>=DATEVALUE("01/10/2012"),DATEVALUE("01-" &B2&"-"&A2)<DATEVALUE("01/03/2014")),C2,0)
paste this formula into D2 and fill down
![]()
=IF(AND(DATEVALUE("01-" &B2&"-"&A2)>=DATEVALUE("01/10/2012"),DATEVALUE("01-" &B2&"-"&A2)<DATEVALUE("01/03/2014")),C2,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks