Cash Flow by Week

[Democat]

I have [column-a] dates and [column-b] corresponding amounts. Column-c thru -x are weekly periods represented by the Wednesday date of each week in [row1].

Can I use the LOOKUP function to find the week [date +- 3days] and place the amount in the proper column? Will an alternative function work better.

Please help. I imagine scheduling amounts by period is a common useage.

[sanskar_d]

I have [column-a] dates and [column-b] corresponding amounts. Column-c thru -x are weekly periods represented by the Wednesday date of each week in [row1].

Can I use the LOOKUP function to find the week [date +- 3days] and place the amount in the proper column? Will an alternative function work better.

Please help. I imagine scheduling amounts by period is a common useage.

Hi Democat,

I think so...

Can you attach an example cause i cant get it quite clear.


regards,

sam

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>

[Rajni R]

Hi!

Would not a simple IF function work?
For your data, try
=IF(AND(($A2<C$1+3),($A2>C$1-3)),$B2,0) in each cell in columns C thru X,
for all rows having data.

This will work best if you have few lines of data.

Rajni

"Democat" <[email protected]> wrote in
message news:[email protected]...
>
> I have [column-a] dates and [column-b] corresponding amounts. Column-c
> thru -x are weekly periods represented by the Wednesday date of each
> week in [row1].
>
> Can I use the LOOKUP function to find the week [date +- 3days] and
> place the amount in the proper column? Will an alternative function
> work better.
>
> Please help. I imagine scheduling amounts by period is a common
> useage.
>
>
> --
> Democat
> ------------------------------------------------------------------------
> Democat's Profile:
> http://www.excelforum.com/member.php...o&userid=24362
> View this thread: http://www.excelforum.com/showthread...hreadid=379602
>