Excel Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1853679%22%20slang%3D%22en-US%22%3EExcel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853679%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20set%20up%20a%20spreadsheet%20with%20Mutiple%20formulas%20the%20updates%20daily%20-%20HELP..............%3C%2FP%3E%3CP%3EI%20am%20very%20new%20to%20excel%20and%20the%20use%20of%20formulas%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EApplication%20received%20i%20need%20to%20input%20date%3C%2FP%3E%3CP%3EDeadline%20date%20needs%20to%20be%2042%20days%20from%20date%20entered%20for%20application%20received%26nbsp%3B%3C%2FP%3E%3CP%3EDays%20remaining%20i%20need%20this%20to%20countdown%20the%2042%20days%3C%2FP%3E%3CP%3EDate%20commenced%20-%20i%20need%20to%20input%20date%3C%2FP%3E%3CP%3EDays%20out%20of%20target%20needs%20to%20be%20number%20of%20day%20%2B%2F-%20from%2042%20day%20countdown%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1853679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1853733%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EA%20day%20is%3D%201%20in%20excel.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eassume%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ecell%20%3CSTRONG%3EA1%3C%2FSTRONG%3E%20contains%20the%20date%20the%20application%20was%20received%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EDeadline%20cell%20%3CSTRONG%3EA2%3C%2FSTRONG%3E%20(make%20sure%20the%20cell%20is%20formated%20as%20date)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DA1%2B42%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDays%20remaining%26nbsp%3B(if%20you%20want%20positive%20numbers)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DA2-TODAY()%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ealternatively%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DTODAY()-A2%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eif%20you%20want%20negative%20numbers%2C%20like%20D-day%20-11%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20so%20on.%20Play%20around%20and%20read%20more%3A%3C%2FP%3E%3CP%3E%3CA%20title%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-subtract-dates-b83768f5-f695-4311-98b1-757345f7e926%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-subtract-dates-b83768f5-f695-4311-98b1-757345f7e926%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-or-subtract-dates-b83768f5-f695-4311-98b1-757345f7e926%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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



1 Reply
Highlighted

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...