Adding an AP to a worksheet automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 07 Nov 2006 21:10 GMT

Hi all,
I've been trying to achieve the above now for a couple of weeks and I've got
nowhere. Please could someone help me?

I have a list of transactions in a worksheet which I need to automatically
count, both by AP and where they were made. I have a start date in cell O4
and a finish date in P4, which contains the dates for AP1, dates for AP2 are
in O5 & P5 respectively. The dates of the transactions is in column C,
starting at cell C3.
I need to put a '1' into cell A3 if the date in C3 is between the dates in
O4 and P4 inclusive, or a '2' if the transaction dates are in O5 and P5.
Does this make sense? If so, I would be extremely grateful for any pointers

TIA

Signature

Regards

Dave

Reply to this Message

Niek Otten - 07 Nov 2006 21:26 GMT

Hi Dave,

What is an AP?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all,
| I've been trying to achieve the above now for a couple of weeks and I've got
[quoted text clipped - 10 lines]
|
| TIA

Reply to this Message

Dave - 07 Nov 2006 21:59 GMT

Sorry - its an accounting period, typically 12 a year. In my case some are 5
weeks , but most are 4 week periods

Signature

Regards

Dave Thurlow
dave@sinfin.org.uk

> Hi Dave,
>
[quoted text clipped - 20 lines]
> |
> | TIA

Reply to this Message