anaturenut
New Member
- Joined
- May 25, 2015
- Messages
- 1
Any help would be greatly appreciated. I have been trying to figure this out for a while now. Thanks in advance for helping me out.
My Headings for each column are: Return Date, Reminder Date and Received Date.
The return date represents when I want something back and could be any date from now to infinity
I have a formula in B2 which says if no date is in A2, then -. If date is typed in on A2, then A2 minus 5 days. So far this formula works.
I am having problems placing a formula in cell B2 to put in the reminder date if a date is in A2 BUT if I type a date in C2, I want B2 to override this and say "N/A" (or, in essence, I don't need to send out a reminder).
A1:Return Date (column header)
B1: Reminder Date (column header)
C1: Received Date (column header)
A2: (No formula in this cell)
B2: =IF(ISBLANK(A2),"-",A2-5)
C2: (No formula in this cell)
My Headings for each column are: Return Date, Reminder Date and Received Date.
The return date represents when I want something back and could be any date from now to infinity
I have a formula in B2 which says if no date is in A2, then -. If date is typed in on A2, then A2 minus 5 days. So far this formula works.
I am having problems placing a formula in cell B2 to put in the reminder date if a date is in A2 BUT if I type a date in C2, I want B2 to override this and say "N/A" (or, in essence, I don't need to send out a reminder).
A1:Return Date (column header)
B1: Reminder Date (column header)
C1: Received Date (column header)
A2: (No formula in this cell)
B2: =IF(ISBLANK(A2),"-",A2-5)
C2: (No formula in this cell)
Last edited:
