I am trying to calculate a current month payment date based on a start date. The workbook contains 12 spreadsheets (one for each month Jan - Dec), in each sheet Coloumn D contains variable start dates approx 100 entries i.e.
1 Jan 2010
26 Jan 2010
3 Feb 2010
17 March 2010 etc....
Coloumn L needs to show the current month payment due date. For example based on the above data if in June spreadsheet payment dates would be
1 June 2010
26 June 2010
3 June 2010
17 June 2010 etc...
If a Start date falls after the current month then the formulae should return 'Not Due' i.e. if the month sheet is Feb but the start date is 17 March 'Not Due' is returned...
Any help would be greatly appreciated....
1 Jan 2010
26 Jan 2010
3 Feb 2010
17 March 2010 etc....
Coloumn L needs to show the current month payment due date. For example based on the above data if in June spreadsheet payment dates would be
1 June 2010
26 June 2010
3 June 2010
17 June 2010 etc...
If a Start date falls after the current month then the formulae should return 'Not Due' i.e. if the month sheet is Feb but the start date is 17 March 'Not Due' is returned...
Any help would be greatly appreciated....