**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