Hello,
I have a spreadsheet setup as follows:
Column A: Description of Expense; Column B: Current Hold Amount; Column C: Total Amount Due;
What I want to accomplish is the following:
1. Based on Today(), calculate how many Fridays have passed in the current month (e.g. 1/27/18 = 4; 1/25/18 = 3) & divide that # by Total amount due to determine Current Hold Amount.
2. Also want the calculation to stop after the last Friday in the month until I "reset" the month. This is to ensure if I am not able to record Current Hold Amount in time before next month's first Friday, the calculation will not reset.
Appreciate any help you can provide.
Thank you!
Jay
I have a spreadsheet setup as follows:
Column A: Description of Expense; Column B: Current Hold Amount; Column C: Total Amount Due;
What I want to accomplish is the following:
1. Based on Today(), calculate how many Fridays have passed in the current month (e.g. 1/27/18 = 4; 1/25/18 = 3) & divide that # by Total amount due to determine Current Hold Amount.
2. Also want the calculation to stop after the last Friday in the month until I "reset" the month. This is to ensure if I am not able to record Current Hold Amount in time before next month's first Friday, the calculation will not reset.
Appreciate any help you can provide.
Thank you!
Jay