Question description:
This user has given permission to use the problem statement for this
blog.
I can't get this formula correct, can someone assist? I am trying to create a date for our posting process based on the payment terms.
If a customer is paying biweekly, with a start date of 3/1/2018, etc. I want to be able to run daily what customers will need to be charged.
=IF(OR(D2="MONTHLY",$C$6+30,")*IF(D2="WEEKLY",$C$6+7,"")*IF(D2="BIWEEKLY",$C$6+14,""""))
Solved by S. H. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/04/2018 - 03:49
Hi
Excelchat Expert
22/04/2018 - 03:49
Welcome to Got it Pro
Excelchat Expert
22/04/2018 - 03:50
Can you paste your sample data so that i can help you better
Excelchat Expert
22/04/2018 - 03:50
Please paste the sample data
Excelchat Expert
22/04/2018 - 03:50
so that i can build formula for you
User
22/04/2018 - 03:51
It is set up a bit different, D2 is a dropdown with MONTHLY, WEEKLY AND BIWEEKLY
Excelchat Expert
22/04/2018 - 03:51
OK
Excelchat Expert
22/04/2018 - 03:51
And what exactly is required
User
22/04/2018 - 03:53
If monthly is there, I would like it to date 30 days from C6, weekly 7 days, and biweekly 14 days. I was able to get this to work with just monthly, I will paste that example
Excelchat Expert
22/04/2018 - 03:53
ok
Excelchat Expert
22/04/2018 - 03:53
Let me build the formula
User
22/04/2018 - 03:54
Thank you ;)
Excelchat Expert
22/04/2018 - 03:54
See now
User
22/04/2018 - 03:55
That looks great! Thank you! Was I just missing one piece, or was I way off?
Excelchat Expert
22/04/2018 - 03:55
Brackets were wrongly placed in yours
Excelchat Expert
22/04/2018 - 03:56
You can caompare both the formula
Excelchat Expert
22/04/2018 - 03:56
Please do give good rating and reviews
Excelchat Expert
22/04/2018 - 03:56
It really helps
User
22/04/2018 - 03:56
Thank you so much! I will!
Excelchat Expert
22/04/2018 - 03:56
Welcome
Excelchat Expert
22/04/2018 - 03:56
Have a good day
User
22/04/2018 - 03:56
You as well!
Excelchat Expert
22/04/2018 - 03:57
You can end the session when done