# Need Help WIth A Formula

Copper Contributor

# Need Help WIth A Formula

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.

2 Replies

# Re: Need Help WIth A Formula

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.