Calculating dates based on 2013 calander

Hi

Happy New Year <--- is it too late to say that.

I'm a bit rusty on spreadsheets as I haven't used them for a while. I am trying to create a spreadsheet that calculates forward load every 2 weeks.

So I assume I'm looking for a formula / function that is able to calculate each day for 14 days from a specific date.

For example, lets say I input "25th January 2013".

Then the following 10 cells will input each date after the above date excluding Saturday and Sunday.

In this case: 28th Jan, 29th Jan, 30th Jan, 31st Jan, 1st Feb, 4th Feb, 5th Feb, 6th Feb, 7th Feb and 8th Feb.

Is this even possible?

Originally Posted by benishiryo

hi aleong, welcome to the forum. assuming your date is in A1, then try:
=WORKDAY(A1,1)

this will add a day, excluding weekends. you could even have a list of holidays inside the 3rd argument

This was exactly what I was looking for, and so simple too. Thank you so much