Fill amount from a cell if date is before end of month

Solved/Closed
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014 - Feb 4, 2014 at 11:49 PM
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014 - Feb 6, 2014 at 09:30 AM
Can someone please help. I'm trying to track outstanding bills due by the end of month as in the following example:

If date in cell B5 (due date) is before cell D11 (end of month date) then fill B12 (outstanding unpaid bill amount) with contents of B4 (monthly bill amount due)

Hawk ^V^

3 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 5, 2014 at 11:12 PM
not clear
try this formula

=IF(B5<=D11,"outstanding"&" "& B4,"")
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014
Feb 6, 2014 at 12:57 AM
This works. Except I deleted the "Outstanding" and am having trouble formatting the cells to currency. It just lists the raw number without currency or the two decimal places. Thanks a ton.
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 6, 2014 at 04:32 AM
try this formula

=IF(B5<=D11,B4,"")
now format B4 as you like
hawkwms Posts 3 Registration date Tuesday February 4, 2014 Status Member Last seen February 6, 2014
Feb 6, 2014 at 09:30 AM
Excellent! Works perfectly! Thanks so much.