IF question dates

[lealeadupont]

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

 

[Micron]

... and the problem/question is?

 

[lealeadupont]

... and the problem/question is?

I need to apply this to a table so I need a IF formula

 

[jtakw]

Hi,

This should do what you want:

Book3.xlsx
	A	B
1	Supply Date	Pay Date
2	1/18/2019	3/31/2019
3	1/18/2018	4/1/2018
4	11/30/2021	1/31/2022
Sheet983

Cell Formulas
Range	Formula
B2:B4	B2	=EOMONTH(A2,2)+IF(WEEKDAY(EOMONTH(A2,2))=7,1,0)

 

[Tetra201]

Another approach (no IF):

=WORKDAY.INTL(EOMONTH(A2,2)-1,1,17)

 

[lealeadupont]

Hi,

This should do what you want:

Book3.xlsx
	A	B
1	Supply Date	Pay Date
2	1/18/2019	3/31/2019
3	1/18/2018	4/1/2018
4	11/30/2021	1/31/2022
Sheet983

Cell Formulas
Range	Formula
B2:B4	B2	=EOMONTH(A2,2)+IF(WEEKDAY(EOMONTH(A2,2))=7,1,0)

thank you so much !!!

 

[jtakw]

You're welcome.