IF statements with dates and criteria
Solved/Closed
jimbabama
Posts
2
Registration date
Monday November 7, 2016
Status
Member
Last seen
November 7, 2016
-
Nov 7, 2016 at 06:20 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 8, 2016 at 06:00 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 8, 2016 at 06:00 AM
Related:
- IF statements with dates and criteria
- How many if statements can you nest - Guide
- If then statements in excel - Guide
- Multiple if statements in excel data validation - Excel Forum
- Vba code to copy data from one sheet to another based on criteria ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Office Software Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 7, 2016 at 06:52 PM
Nov 7, 2016 at 06:52 PM
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 8, 2016 at 06:00 AM
Nov 8, 2016 at 06:00 AM
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
Nov 7, 2016 at 08:10 PM