A4=TEXT($A$1&
VLOOKUP($A$2,{"Monday",1;"Tuesday",2;"Wednesday",3 ;"Thurday",4;"Friday",5;"Saturday",6;"Sunday",7},2 ,0)+(7*(ROWS($1:1)-1)),"d mmm yyyy")

drag from A4 down as far as needed


"lesg46" wrote:

I need to return the correct date based on the day of week and month of year.
e.g.
in A1 I type January
in A2 I type Monday

in A4 I want the result 1 Jan 2007
in A5 I want 8 Jan 2007
etc.
So that if I change either the month or day in A1 or A2, the results will
change automatically.
Please can anyone help? This is driving me mad!!
Thanks