Forum Discussion
Need Help WIth A Formula
Hello please refer to picture,
I am trying to add a function where the monthly charge automatically gets added to corresponding month. So the flow would go, Date In gets entered, "Storage fee applies" column is already set to add 30 days, a monthly charge is calculated, once the 30 days is up i need it to input the charge into the corresponding month cell. I would appreciate any help because I've been trying to work on it all day.
Thank you.
- Hello brichard98
"Hello please refer to picture," this is useless without column and row headers! And for me it made the question even more confusing. REMEMBER you KNOW this worksheet inside out and WE DO NOT so its up to you to make the question as understandable as could be! it does get you the best results!
Having said that, I think what you need is a condition to text. Here is how I understood your question and the formula that I think you will need
=IF(A1>=B1,"Amount Due","Not yet")
So in Cell A1 you will have today's date (You can do that in many ways type it in, or use CTRL+:)
in Cell B1 you have the date in A1 + 30 days
The formula say: If Today's date (cell A1) is Greater or equal to Today+30 days (cell B1) Then the amount is due otherwise its not yet due. You can change the "Amount Due" and the "Not yet" to anything you want to display.
Make sure you adjust the cells A1 and B1 to where your data is.
Hope I understood your question and that this will help you get started.GeorgieAnneThank you for a response. I posted a better picture of what I'm doing. I'm still not exactly understanding what to do. I'm trying to get the monthly storage charge to automatically enter into the corresponding month cell once the fee date is applied. In the picture, for example, I have a storage fee applied on 1-19-2024. How would I input the storage fee in the month cell? Is "=IF(D13<=E7)" a good start to the function or is that completely wrong?
