Populate cell if another cell is a certain weekday

  • Thread starter Thread starter Maddoktor
  • Start date Start date
M

Maddoktor

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.
 
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
 
Back
Top