If Then rule with dates help

Closed
Valkrie - 18 Sep 2015 à 16:59
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 18 Sep 2015 à 19:40
Hello,

I'm trying to figure out a formula to calculate adding 84 days to an original date. However, if the calculated date does not fall on a Sunday, to add those days until it does. So for example, if you add 84 days to today's date, it is 12/11/2015, but it falls on a Friday. How can I add the If rule to have it add the 2 days to make it Sunday?

Thanks!
Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
18 Sep 2015 à 19:40
Valkrie, Good evening.

Suppose your date is at A1.

B1 -->
=IF(WEEKDAY(A1+84,2)=7,A1+84;A1+84+7-WEEKDAY(A1+84,2))


Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão