Date calculation help

[svenopi]

Hi Everybody,

I work for a company that has a lot of projects with a deadlines, usually we prepare for our projects 110 days in advance, so if the project is due to be finished on 01/07/2017, we need to start planning 13/03/2017, so we just substract the 110 days from the date and get our date of planning start. My problem is, by calculating it that way, we often get a start day of planning that falls on saturday. Is there a way to ssubstract one number out of a range of 110 to 116 days before the dealine based on which of these days is a monday.
If you need any more information, please reply as well, and thank you for the help in advance.

 

[footoo]

=a1-109-weekday(a1-111)

 

[Tetra201]

Assuming your deadline date is in cell A1, try this:

=WORKDAY.INTL(A1-109,-1,"0111111")

 

[daverunt]

Hi,

I haven't used it myself but look at/google the workday function for examples.

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/worksheetfunction-workday-method-excel