If Date Cell Less Than Todays Date Calculate Difference In Days
I have column B with a heading "Days Remaining" and column L with a heading "Deadline".
starting with row 5, I need to be able to enter a date in L5 and see the days I have left, from that day untill today, on B5.
I need to then be able to enter a date into L6 and see a result in B6 and on and on.
Then I need to be able to insert or delete a column and have the formulas still work in the columns with the heading "Days Remaining" and "Deadline"
Video Tutorials / Excel Dashboards Reports