carramos12
New Member
- Joined
- Mar 6, 2020
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Need the following two functions in same cell:
1. 1st function calculate 5 day due date in V6: =B6+5
2. 2nd function keep cell blank (V6) until data entered in B6: =IF(ISBLANK(B6),"",B6)
2nd scenario similar to 1st scenario:
1. 1st function copy date in AC6: =B6
2. 2nd function keep cell blank (AC6) until data entered in B6: =IF(ISBLANK(B6),"",B6)
Thank you
1. 1st function calculate 5 day due date in V6: =B6+5
2. 2nd function keep cell blank (V6) until data entered in B6: =IF(ISBLANK(B6),"",B6)
2nd scenario similar to 1st scenario:
1. 1st function copy date in AC6: =B6
2. 2nd function keep cell blank (AC6) until data entered in B6: =IF(ISBLANK(B6),"",B6)
Thank you