G Guest Dec 4, 2003 #1 I need to setup a bank statement that will include post dated checks...need to have daily total not showing post dated checks ..... with still seeing when they will be coming out. HELP
I need to setup a bank statement that will include post dated checks...need to have daily total not showing post dated checks ..... with still seeing when they will be coming out. HELP
B Bernie Deitrick Dec 4, 2003 #2 JSK, With dates in column B and amounts in column C: =SUMIF(B:B,"<" &NOW(),C:C) will show the sum of checks that aren't post-dated. HTH, Bernie MS Excel MVP JSK said: I need to setup a bank statement that will include post dated Click to expand... checks...need to have daily total not showing post dated checks ..... with still seeing when they will be coming out. HELP
JSK, With dates in column B and amounts in column C: =SUMIF(B:B,"<" &NOW(),C:C) will show the sum of checks that aren't post-dated. HTH, Bernie MS Excel MVP JSK said: I need to setup a bank statement that will include post dated Click to expand... checks...need to have daily total not showing post dated checks ..... with still seeing when they will be coming out. HELP
