Subtracting Business Days from a Date

J

jennyspecial

New Member
Joined
Nov 10, 2011
Messages
1
I'm trying to subtract 25 business days from an actual date, ie. what date was 25 days before Nov 11, 2011, where the 11th is the 26th day. Thanks
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
=WORKDAY(A1,-25)
where A1 contains the date in question
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Adding calendar days but result needs to be preceding business day
Replies
5
Views
335
aliecat08
A
J
  • Question
How to convert calendar days to business days
2
Replies
11
Views
635
Fluff
Fluff
H
  • Question
#Value! result for date subtraction formula
Replies
9
Views
60
Joe4
Joe4
F
  • Question
Take date/time and calculate the time in between excluding weekends and including partial days
Replies
5
Views
318
awoohaw
awoohaw
L
  • Solved
Subtracting Dates to Last Row
2
Replies
10
Views
193
Joe4
Joe4

Forum statistics

Threads
1,203,545
Messages
6,056,031
Members
444,840
Latest member
RazzelDazel

Share this page

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