Auto calculate first Monday of the month

[Marklarbear]

Hi All,

In a FTE forecast spreadsheet that I maintain, I want to be able to automate how a certain date is calculated.

Scenario: On the third wedneday of each month I produce a 12 month FTE forecast. On the 1st monday of the next month the executive management meet to discuss my reccomendations based on the FTE forecast.

Issue: how (in the spreadsheet) can I get excel to automatically insert the 1st mondays date of the month based on the previous months 3rd wednesdays date???

 

[Legacy 21301]

Or :-

=EOMONTH(A1,0)+8-WEEKDAY(EOMONTH(A1,0)-1)

 

[bosco_yip]

Book2
	A	B	C	D	E	F	G	H
1	21/01/2004	18/02/2004	17/03/2004	21/04/2004	26/05/2004	20/06/2004	4/07/2004
2	2/02/2004	1/03/2004	5/04/2004	3/05/2004	7/06/2004	5/07/2004	2/08/2004
3
4
Sheet1

Or ………

=DATE(YEAR(A1),MONTH(A1)+1,0)+(7-MOD(DATE(YEAR(A1),MONTH(A1)+1,0)-2,7))

Regards