Returning Nth day in a certain week each month

[ardykav]

Hi All,

I have a sheet where i want to enter one row and it then automatically calculates all the dates below it.

However the problem I have is that i want it to calculate every nth day in a certain month so not sure what the formula or code is.

Eg I have the following table:[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]End date[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]14/04/16[/TD]
[TD]Monthly[/TD]
[TD]31/12/16[/TD]
[TD]John Smith[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

When I refer to monthly it means that every service should be at the same time each month, so in the first case it would be every 2nd Thursday of the month. So Row 2 would then have formulas that would calculate to return values up to the end date. So here it should then look like this and end on 31/12/16
[TABLE="width: 500"]
<tbody>[TR]
[/TR]
[TR]
[TD]Start Date[/TD]
[TD]Frequency[/TD]
[TD]End date[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]14/04/16[/TD]
[TD]Monthly[/TD]
[TD]31/12/16[/TD]
[TD]John Smith[/TD]
[/TR]
[TR]
[TD]12/05/16[/TD]
[TD]Monthly[/TD]
[TD]31/12/16[/TD]
[TD]John Smith[/TD]
[/TR]
[TR]
[TD]09/06/16[/TD]
[TD]Monthly[/TD]
[TD]31/12/16[/TD]
[TD]John Smith[/TD]
[/TR]
[TR]
[TD]14/07/16[/TD]
[TD]Monthly[/TD]
[TD]31/12/16[/TD]
[/TR]
</tbody>[/TABLE]

Would i need to put a formula in Column A and if so what would it be or would i need VBA code to work it out?

All help greatly appreciated,

thanks

 

[asad]

Have a look at post #5 in this Finding the 2nd Tuesday and 2nd Wednesday of Every Month & Labeling them
May be it will help you.

 

[ardykav]

Have a look at post #5 in this Finding the 2nd Tuesday and 2nd Wednesday of Every Month & Labeling them
May be it will help you.

Thank you, not exactly what I wanted but I think I have found a workaround, thanks a lot