Date Formula

[Kumara_faith]

HI,

In cell B3, I have the start date and cell C3 I have the end date.

In cell D3, I need a formula that should provide the remaining balance days from the current day compared to the end date, excluding saturday/sundays/holidays.

Appreciate help.

Thanks.

[Kieran]

Teh NETWORKDAYS function will provide thsi answer.
it is only availble if you have aded the ANALYSIS toolpack under the tools>add-ins command.

The online help is fairly informative, but post back if you have issues.

[VBA Noob]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

[Kumara_faith]

Hi VBA Noob,

My apologies. The following post isn't exactly the same 100% as the cross post but here is the link for the cross post. I did not post the link as it was not a 100% same. My apologies again:

http://www.mrexcel.com/forum/showthread.php?t=364510

[DonkeyOte]

See NETWORKDAYS in XL Help, eg

=NETWORKDAYS(TODAY(),C3,holiday_range)

where holiday_range is a named range containing your public holiday dates.

(requires Analysis ToolPak be activated via Tools -> Addins)

[Kumara_faith]

DonkeyOte,

Thank you for your solution. The problem is now solved.

Thank you again for your time and patience.