Require a formula to subtract holidays progrsssively from a start amount

**john dalton** · 06-19-2014, 04:10 AM

Hi I have a list of holidays for employees and I need to progressively deduct them from a start amount.

Please see attached example for details.

Thanks in advance

JD

**Fotis1991** · 06-19-2014, 04:38 AM

Hi

Do you mean?

Formula:

Please Login or Register  to view this content.

Copy down.

**john dalton** · 06-19-2014, 04:58 AM

Hi Fotis the desired outcome would be the progressive deduction in row C of the example your formula takes care of the column G requirement of the total remaining.

Cheers

JD

**Fotis1991** · 06-19-2014, 07:07 AM

Ok John,

Then.

Formula:

Please Login or Register  to view this content.

**john dalton** · 06-19-2014, 08:31 AM

Brilliant solution Fotis, much appreciated.

JD

Require a formula to subtract holidays progrsssively from a start amount

LinkBack

Thread Tools

Rate This Thread

Display

Require a formula to subtract holidays progrsssively from a start amount

Re: Require a formula to subtract holidays progrsssively from a start amount

Re: Require a formula to subtract holidays progrsssively from a start amount

Re: Require a formula to subtract holidays progrsssively from a start amount

Re: Require a formula to subtract holidays progrsssively from a start amount

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Require a formula to eliminate names from a list as they are allocated holidays

[SOLVED] Require a formula to see if 2 dates fall within Year end and Start

Require formula to look at multiple variables to give a rebate amount based on % turnover

Need a formula to calculate holidays from start dates to the current date!

[SOLVED] Formula for amount owing subtract amount paid

Bookmarks

Bookmarks

Posting Permissions