Populate cell if another cell is a certain weekday

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maddoktor - 07 Aug 2007 23:53 GMT

Hi all,

I would like help with the following:

A1 : Start Date
A2 : End Date
A3 : $500

I would like to populate cells A4 to A34 with dates between and
including start date (A1) and end date (A2).

Then cells between B4 to B34 should only populate with the value in A3
if the date in cells A4 to A34 is a Thursday.

Thank you in advance for your help.

Reply to this Message

Gary''s Student - 08 Aug 2007 00:34 GMT

In A1:
8/7/2007
In A2:
9/6/2007
In A4:
=A1
In A5:
=A4+1 and copy down
In B4:
=IF(WEEKDAY(A4)=5,$A$3,"") and copy down. You should see:

8/7/2007
9/6/2007
500
8/7/2007
8/8/2007
8/9/2007    500
8/10/2007
8/11/2007
8/12/2007
8/13/2007
8/14/2007
8/15/2007
8/16/2007    500
8/17/2007
8/18/2007
8/19/2007
8/20/2007
8/21/2007
8/22/2007
8/23/2007    500
8/24/2007
8/25/2007
8/26/2007
8/27/2007
8/28/2007
8/29/2007
8/30/2007    500
8/31/2007
9/1/2007
9/2/2007
9/3/2007
9/4/2007
9/5/2007
9/6/2007    500

Signature

Gary''s Student - gsnu200736

> Hi all,
>
[quoted text clipped - 11 lines]
>
> Thank you in advance for your help.

Reply to this Message

Rate this thread: