I have a date range:
Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End.
Can anyone help?
=IF([Actual Completion Date]@row > [Date Range
I have this formula:
=IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE")
I've tried a few things but I keep getting invalid operation, and I'm sure it's something foolish and easy but I can't seem to figure it out.
I have this formula to add 10 days to a date:
=[Date1]@row + 10
Then I have this formula to leave blank if there is no date:
I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in
I have this formula that works great:
=DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3)))
But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can I add so it stays blank if I have no date in "[Completion Date]3".
I have a Completion Date of 1/08/2019 and I need the next cell to be 1/29/2019 (which is ten days before 2/8/2019) and the third cell to be 2/18/2019 (which is ten days after 2/8/2019). I've tried every which way I could think of to get this to work. Any ideas?
I am currently using this:
=IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red"))))
Which is working but I try to add this:
IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow"
I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done?
So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection.