Returning Nth day in a certain week each month

ardykav

Board Regular
Joined
Oct 18, 2015
Messages
102
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:
Start DateFrequencyEnd dateName
14/04/16Monthly31/12/16John Smith

<tbody>
</tbody>

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
Start DateFrequencyEnd dateName
14/04/16Monthly31/12/16John Smith
12/05/16Monthly31/12/16John Smith
09/06/16Monthly31/12/16John Smith
14/07/16Monthly31/12/16

<tbody>
</tbody>

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
 

Forum statistics

Threads
1,082,447
Messages
5,365,574
Members
400,838
Latest member
Renedescartes

Some videos you may like

This Week's Hot Topics

Top