If Then rule with dates help
Closed
Valkrie
-
Sep 18, 2015 at 04:59 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 18, 2015 at 07:40 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 18, 2015 at 07:40 PM
Related:
- If Then rule with dates help
- Defcon dates - Guide
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Vivatech 2024 dates - Guide
- If function for dates - Guide
- Using nested if to blank out adjacent cells - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 18, 2015 at 07:40 PM
Sep 18, 2015 at 07:40 PM
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