# IF question dates

##### New Member
Hi!
I have this question but don't know how to manage that

Company pays to its suppliers at the end of next two months from the supply
date. Example: If the supply date is 18/01/2019, then then payment will be
31/03/2019, always at the end of next two months. If the payment day is
Saturday, then the company postpones the payment to Sunday. Example: if
the supply date is 18/01/2018 then the payment day will be 01/04/2018
(because 31/03/2018 is Saturday).

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
... and the problem/question is?

... and the problem/question is?
I need to apply this to a table so I need a IF formula

Hi,

This should do what you want:

Book3.xlsx
AB
1Supply DatePay Date
21/18/20193/31/2019
31/18/20184/1/2018
411/30/20211/31/2022
Sheet983
Cell Formulas
RangeFormula
B2:B4B2=EOMONTH(A2,2)+IF(WEEKDAY(EOMONTH(A2,2))=7,1,0)

Another approach (no IF):
Excel Formula:
``=WORKDAY.INTL(EOMONTH(A2,2)-1,1,17)``

Hi,

This should do what you want:

Book3.xlsx
AB
1Supply DatePay Date
21/18/20193/31/2019
31/18/20184/1/2018
411/30/20211/31/2022
Sheet983
Cell Formulas
RangeFormula
B2:B4B2=EOMONTH(A2,2)+IF(WEEKDAY(EOMONTH(A2,2))=7,1,0)
thank you so much !!!

You're welcome.

Replies
18
Views
541
Replies
5
Views
267
Replies
1
Views
277
Replies
5
Views
361
Replies
3
Views
80

1,203,742
Messages
6,057,112
Members
444,905
Latest member
Iamtryingman

### 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.

### Which adblocker are you using?

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

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