Start date and calculate end date, skip weekends!

[jochem_zw]

Hi,

i like to calculate a end date for example start date 7-5-2013 (7 may 2013)

Duration is 12 days, but i have to exclude the weekends. My end date has to be 22-5-2013.

What formula can i use, i tried some things with networkdays etc. but till now not the desired result.

Hope someone can help me.

[Gysbert_Wassenaar]

What you're looking for is the lastworkdate function. lastworkdate('7-5-2013', 12) should return 22-5-2013. Make sure you're using the correct date format. Use the date# and/or date functions as necessary.

[jochem_zw · Accepted solution]

thnx Gysbert this was exactly what is was looking for!

[gaurav2017]

Hi,

Please close this issue if you got what you were looking for.

Regards,