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
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)
Thanks in advance.
Hawk ^V^
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^
Related:
- Fill amount from a cell if date is before end of month
- If cell contains date then return value ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- Count if cell contains number - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
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
Feb 5, 2014 at 11:12 PM
not clear
try this formula
=IF(B5<=D11,"outstanding"&" "& B4,"")
try this formula
=IF(B5<=D11,"outstanding"&" "& B4,"")
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 6, 2014 at 04:32 AM
Feb 6, 2014 at 04:32 AM
try this formula
=IF(B5<=D11,B4,"")
now format B4 as you like
=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
Feb 6, 2014 at 09:30 AM
Excellent! Works perfectly! Thanks so much.
Feb 6, 2014 at 12:57 AM