| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return dates based on month and day of week
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 |
Threaded Mode
