Previous Topic Next Topic

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

Solved/Closed
hawkwms Posts 3 Registration date Tuesday 4 February 2014 Status Member Last seen 6 February 2014 - 4 Feb 2014 à 23:49
hawkwms Posts 3 Registration date Tuesday 4 February 2014 Status Member Last seen 6 February 2014 - 6 Feb 2014 à 09:30
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)

Thanks in advance.
Hawk ^V^

3 responses

Réponse 1 / 3
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
5 Feb 2014 à 23:12
not clear
try this formula

=IF(B5<=D11,"outstanding"&" "& B4,"")
hawkwms Posts 3 Registration date Tuesday 4 February 2014 Status Member Last seen 6 February 2014
6 Feb 2014 à 00:57
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.
Réponse 2 / 3
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
6 Feb 2014 à 04:32
try this formula

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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response