Hello All:
I need some code. I have 40 cells that may/may not contain dates. Range is H19:H38 and I19:I38. Here is my need via example. If H19 has a date and I19 is empty, I need to know how many days (based on the current date) until the date in H20. If H19 and I19 have dates and If H20 has a date and I20 is empty, I need to know how many days until the date in H21. Range H19:H38 are planned task dates. I19:I38 are actual task completion dates. The cells in the range H19:H38 may contain a dates (sequentially) in all 20 cells or some number less than 20 cells (task may take 20 steps to complete or some number less than 20 steps). For every date entered in H19:H38, a date should eventually be placed on the same row in the range I19:I38. Output should be in B44. The code must work in several tabs but not all tabs. Thank you for the assistance
I need some code. I have 40 cells that may/may not contain dates. Range is H19:H38 and I19:I38. Here is my need via example. If H19 has a date and I19 is empty, I need to know how many days (based on the current date) until the date in H20. If H19 and I19 have dates and If H20 has a date and I20 is empty, I need to know how many days until the date in H21. Range H19:H38 are planned task dates. I19:I38 are actual task completion dates. The cells in the range H19:H38 may contain a dates (sequentially) in all 20 cells or some number less than 20 cells (task may take 20 steps to complete or some number less than 20 steps). For every date entered in H19:H38, a date should eventually be placed on the same row in the range I19:I38. Output should be in B44. The code must work in several tabs but not all tabs. Thank you for the assistance
