Subtract 3 business days from date

[Jibroni]

In column A every cell is a different date. In column B, I want to put in a date that is three business days prior to the date in the other column. For example, if A2 date is 6/5/2022, cell B2 needs to be 6/1/2022 (three business days prior). I need a macro that fills in every cell in column B if column A has a date in it. I assume there is a formula that will work, but when I try this formula for example, "=WORKDAY(F2-3,1)" it returns 6/3/2022, which is not the date I am expecting.

 

[jtakw]

Hi,

Your formula syntax is incorrect, try this:

=WORKDAY(A2,-3)

 

[Jibroni]

Hi,

Your formula syntax is incorrect, try this:

=WORKDAY(A2,-3)

Hi @jtakw thank you for catching that. This formula gives me what i need for that specific cell. Is there a formula I can drag down to insert dates in all the cells that have dates in column A?

 

[jtakw]

Just drag that formula down column.

Book3.xlsx
	A	B
1
2	6/5/2022	6/1/2022
3	6/6/2022	6/1/2022
4	6/7/2022	6/2/2022
5	6/8/2022	6/3/2022
6	7/5/2022	6/30/2022
7	7/6/2022	7/1/2022
8	7/7/2022	7/4/2022
9	7/8/2022	7/5/2022
10	7/9/2022	7/6/2022
11	8/1/2022	7/27/2022
12	8/2/2022	7/28/2022
13	8/3/2022	7/29/2022
14	8/4/2022	8/1/2022
Sheet1085

Cell Formulas
Range	Formula
B2:B14	B2	=WORKDAY(A2,-3)

 

[Jibroni]

Just drag that formula down column.

Book3.xlsx
	A	B
1
2	6/5/2022	6/1/2022
3	6/6/2022	6/1/2022
4	6/7/2022	6/2/2022
5	6/8/2022	6/3/2022
6	7/5/2022	6/30/2022
7	7/6/2022	7/1/2022
8	7/7/2022	7/4/2022
9	7/8/2022	7/5/2022
10	7/9/2022	7/6/2022
11	8/1/2022	7/27/2022
12	8/2/2022	7/28/2022
13	8/3/2022	7/29/2022
14	8/4/2022	8/1/2022
Sheet1085

Cell Formulas
Range	Formula
B2:B14	B2	=WORKDAY(A2,-3)

Ah perfect. Thank you!

 

[jtakw]

You're welcome, thanks for the feedback.