Formulas to find the suitable dates

Hello MisterExcellent and Marcelo,

Hello Barry,

I would like to thank you for the formula which has solved my problem, and for your attention that has been devoted to my problem.

I'm now using your formula without the add-in functions which calculates the expected result.

I thank you for your support and wish you a nice day.

Flowers for you, Barry!

www.MessenTools.com-Varios-big-220.gif
 
Last edited:
Upvote 0

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Hi Barry.

Hey Marcelo,

I can't thank you enough! I am grateful for you support.
After Markmzz wrote me, that something is unsuitable in your formula, I checked this and couldn't find another way till you highlighted Barry's solution.

Thank you so much for your help and for your support all the time, Marcelo

PrayingAngelSmiley.gif
 
Upvote 0
MisterExcellent,

Hi Mark,

You are very kind and friendly. Thank you so much that you haven't felt you disturbed my personal message and helped me.

At beginning of this thread I thought that the solution should be as it is possible with your formula.
Excuse me, I gave the examples but only after I saw the solution of Barry I knew that it is the right solution.
It's my fault for your effort.

This is an ingeniously formula which have created.
I think that I will use this formula for a specific occasion.

Thank you very much

you-re-the-best.gif
 
Upvote 0
Hi Mark,

You are very kind and friendly. Thank you so much that you haven't felt you disturbed my personal message and helped me.

At beginning of this thread I thought that the solution should be as it is possible with your formula.
Excuse me, I gave the examples but only after I saw the solution of Barry I knew that it is the right solution.
It's my fault for your effort.

This is an ingeniously formula which have created.
I think that I will use this formula for a specific occasion.

Thank you very much

MisterExcellent,

Thanks for the feedback. And what is important is that you solved your problem.

Markmzz
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,291
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top