Workdays with edate

[Gazlar]

Hi guys,

i am trying to get edate working with workday.

I have this but keep getting errors


=IF(H950="1 month",WORKDAY(EDATE(E950,1),IF(H950="Hold (12 months)",WORKDAY(EDATE(E950,12),""))))



I Need it to only calculate workdays and not weekends. I use the below, but it includes weekends.

=IF(H954="1 month",EDATE(E954,1),IF(H954="Hold (12 months)",EDATE(E954,12),""))

you help is appreciated.

Gary

 

[Habtest]

The WORKDAY formula is missing arguments probably due to misplaced brackets. Assuming you are looking for the first working day 1 or 12 months after, please try:

=IF(H950="1 month",WORKDAY(EDATE(E950,1)-1,1),IF(H950="Hold (12 months)",WORKDAY(EDATE(E950,12)-1,1),""))

 

[Gazlar]

The WORKDAY formula is missing arguments probably due to misplaced brackets. Assuming you are looking for the first working day 1 or 12 months after, please try:

=IF(H950="1 month",WORKDAY(EDATE(E950,1)-1,1),IF(H950="Hold (12 months)",WORKDAY(EDATE(E950,12)-1,1),""))

It works excellent, but the double “” on the end doesn’t, it tells me too many arguments and I need the cell to be blank if no date is calculated.

 

[Habtest]

Works fine here, can you upload by Xl2bb or screenshot what went wrong?

Book1
	A	B	C	D	E	F	G	H
950	6/1/2021				5/1/2021			1 month
951	5/2/2022				5/1/2021			Hold (12 months)
952					5/1/2021			x
Sheet1

Cell Formulas
Range	Formula
A950:A952	A950	=IF(H950="1 month",WORKDAY(EDATE(E950,1)-1,1),IF(H950="Hold (12 months)",WORKDAY(EDATE(E950,12)-1,1),""))

 

[Gazlar]

Thank you, this does work, I noticed that I missed the 2nd workday( out, put it in a nd it works like a dream,.

very much appreciated thanks for all your help.

Gaz

 

[Habtest]

You are welcome, glad it works, thanks for the feedback!