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
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 18 Sep 2015 à 19:40
Related:
- If Then rule with dates help
- Iphone 14 release dates - Home - IOS
- Vivatech 2024 dates - Guide
- Excel if function with dates - Guide
- Blackhat dates - Guide
- Outlook rule not working - Guide
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
18 Sep 2015 à 19:40
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
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