CODEWITHSUNDEEP
excelexcel-formula
handpaintedstudio
handpaintedstudio

Reputation: 13

Find days remaining until due date minus weekends in excel

I've been trying to configure a formula using the function MAX and TODAY to return the days remaining until the due date minus the weekends.

I'm using the 'Timeline' column entry to calculate the 'Due' date column =WORKDAY.INTL(Data!$H5-1,Data!$I5,1). So, the issue I'm having and I'm not able to find why is within the 'Remaining(days)' column formula to find the remaining days from the current date today =MAX(0,Data!$J5-TODAY()).

Excel, start date, timeline(days), due date, remaining(days)

Any pointers or help would be very appreciated, thanks!

Upvotes: 0

Views: 1054

Answers (2)

mjl
mjl

Reputation: 50

Use =IF([TimelineDays]<0,0,NETWORKDAYS.INTL(TODAY(),[DueDate],1)), this will return exactly the days remaining minus the weekends plus any days that are prior to your starting date if your start date is before today or the current date.

Upvotes: 0

teylyn
teylyn

Reputation: 35955

Excel's function NETWORKDAYS() does that.

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.

https://support.office.com/en-us/article/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7

Upvotes: 1

Related Questions