I need to set up a spreadsheet with Mutiple formulas the updates daily - HELP..............
I am very new to excel and the use of formulas
Application received i need to input date
Deadline date needs to be 42 days from date entered for application received
Days remaining i need this to countdown the 42 days
Date commenced - i need to input date
Days out of target needs to be number of day +/- from 42 day countdown
A day is= 1 in excel.
cell A1 contains the date the application was received
Deadline date cell A2 (make sure the cell is formated as date)
Days remaining (if you want positive numbers). Makes sure this cell is NOT date (you can press Ctrl+0 in that cell).
if you want negative numbers, like D-day -11
And so on. Play around and read more: