Help Anong excel formula para dito?

[BounceBounce]

ano formula dito?
bali pag naglagay ako ng due date automatic na may lalabas na remaining days
pero yung remaining days, kusang magbabawas yun at magbabase sa system time, mauubos lang siya pag nareach na niya yung due date
baka may alam, salamat!
ps. hindi po ito gagamitin for academic purposes, pangpersonal lamang salamat!

 

[P0tchie]

pang trading bayang data mo?

 

[inusena]

=A1-TODAY()
or
=A1-NOW()

format cells as number

 

[BounceBounce]

hindi

 

[BounceBounce]

lumalabas #value!

 

[inusena]

[XX='BounceBounce, c: 656071, m: 538952'][/XX] patingin

 

[inusena]

[XX='BounceBounce, c: 656071, m: 538952'][/XX] format cells mo as number

 

[BounceBounce]

ok na paps naset na system date lang nagkaproblema

 

[inusena]

[XX='BounceBounce, c: 657096, m: 538952'][/XX] ok po