IF statements with dates and criteria
Solved/Closed
jimbabama
Posts
2
Registration date
Monday 7 November 2016
Status
Member
Last seen
7 November 2016
-
7 Nov 2016 à 18:20
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Nov 2016 à 06:00
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 8 Nov 2016 à 06:00
Related:
- Different dates of "end to end encryption message" on blank chat?
- Message request on instagram disappeared - Guide
- Different dates of end-to-end encryption message on blank chat whatsapp - Excel Forum
- Sophos free encryption - Download - Encryption and decryption
- Random chat - Facebook Messenger Forum
- Msn chat history - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
7 Nov 2016 à 18:52
7 Nov 2016 à 18:52
jimbabama, Good evening.
Try to use:
C1 --> =IF(A1=B1, B1, B1+14)
Format A, B and C cells as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
C1 --> =IF(A1=B1, B1, B1+14)
Format A, B and C cells as DATE
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
8 Nov 2016 à 06:00
8 Nov 2016 à 06:00
Thanks for the feedback.
Glad to be of help!
--
Belo Horizonte, Brasil.
Marcílio Lobão
Glad to be of help!
--
Belo Horizonte, Brasil.
Marcílio Lobão
7 Nov 2016 à 20:10