Excel Formulas

[kerryA_1977]

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

[#2]

A day is= 1 in excel. 

assume:

cell A1 contains the date the application was received 

Deadline date cell A2 (make sure the cell is formated as date)

=A1+42

Days remaining (if you want positive numbers). Makes sure this cell is NOT date (you can press Ctrl+0 in that cell). 

=A2-TODAY()

alternatively:

=TODAY()-A2

if you want negative numbers, like D-day -11

And so on. Play around and read more:

https://support.microsoft.com/en-us/office/add-or-subtract-dates-b83768f5-f695-4311-98b1-757345f7e92...