Excel 2007 : Formula which: Finds month's last working day, sum's mon. results, divide by monthly targ

**spiros63** · 06-11-2012, 08:06 AM

Hi guys,

What we need is a formula which :

1 : will finds the last working day of each month, then
2 : summarizing the results of the given month, and then
3 : divide the summarized results by the monthly target

The expected outcome should be like in the example

The tricky part is:
1: the column containing dates is auto-filled by formula, which returns working days minus holidays
2: separate of the date-column there is a cell which contains a choosable date. This is a master cell. When this change, the date sequence change

In the uploaded file you'll find a detailed example.

I'd greadly appreciate any help

**Fotis1991** · 06-13-2012, 06:14 AM

Hi

Σπύρο(Spiros), an easy way(using a helper Column, let's say R), is this.

In R5 and copy down.

Please Login or Register  to view this content.

In I5 and copy down

Please Login or Register  to view this content.

In J5 and copy down.

Please Login or Register  to view this content.

I give Names to ranges(Month, Result)

Also, i use Conditional Formatting, to highlight the results.

Hope, this helps.

**spiros63** · 06-13-2012, 06:55 AM

Originally Posted by Fotis1991

Hi

Σπύρο(Spiros), an easy way(using a helper Column, let's say R), is this.

In R5 and copy down.

Please Login or Register  to view this content.

In I5 and copy down

Please Login or Register  to view this content.

In J5 and copy down.

Please Login or Register  to view this content.

I give Names to ranges(Month, Result)

Also, i use Conditional Formatting, to highlight the results.

Hope, this helps.

Fotis good afternoon,

Unfortunately I'm out of the office and I can't review the solution you just send me.
As soon as I get back I'll deal with it.
Anyway

Thanks for your help.
This thread was unanswered for quite a time (in relevant to already known to me as response time)

Excel 2007 : Formula which: Finds month's last working day, sum's mon. results, divide by monthly targ

LinkBack

Thread Tools

Rate This Thread

Display

Formula which: Finds month's last working day, sum's mon. results, divide by monthly targ

Re: Formula which: Finds month's last working day, sum's mon. results, divide by monthly t

Re: Formula which: Finds month's last working day, sum's mon. results, divide by monthly t

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions