Thread
:
Adding an AP to a worksheet automatically
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Dave
external usenet poster
Posts: 4
Adding an AP to a worksheet automatically
Sorry - its an accounting period, typically 12 a year. In my case some are 5
weeks , but most are 4 week periods
--
Regards
Dave Thurlow
"Niek Otten" wrote in message
...
Hi Dave,
What is an AP?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Dave" wrote in message
...
| 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
|
| --
|
| Regards
|
| Dave
|
|
Reply With Quote
Dave
View Public Profile
Find all posts by Dave