Excel date computation

%3CLINGO-SUB%20id%3D%22lingo-sub-1582582%22%20slang%3D%22en-US%22%3EExcel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582582%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20is%20there%20a%20way%20to%20compute%20a%20rolling%20date%20in%20an%20excel%20cell%3F%20Given%20a%20start%20date%20I%20want%20to%20calculate%20a%20daily%20value%20in%20a%20cell%2C%20that%20updates%20with%20each%20new%20day.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1582582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582603%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582603%22%20slang%3D%22en-US%22%3Eif%20you%20place%20a%20date%20in%20cell%20a1%2C%20%3DTODAY()-(A1)%20will%20give%20you%20a%20count%20from%20that%20date%20until%20today.%20You%20must%20format%20the%20formula%20with%20number%20or%20general%20format%2C%20not%20date%20format.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582609%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582609%22%20slang%3D%22en-US%22%3Eis%20there%20a%20way%20for%20it%20to%20calculate%20a%20new%20value%20each%20day%3F%20or%20would%20I%20have%20to%20enter%20in%20a%20date%20each%20day%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582795%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582795%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756332%22%20target%3D%22_blank%22%3E%40heatherjixf%3C%2FA%3E%3C%2FP%3E%3CP%3ENot%20sure%20what%20you%20mean%20here.%20do%20you%20mean%20you%20want%20multiple%20dates%3F%20Could%20you%20attach%20an%20example%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582868%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740158%22%20target%3D%22_blank%22%3E%40Poogermum%3C%2FA%3E%26nbsp%3BI%20want%20to%20compute%20a%20daily%20amount%20that%20updates%20with%20each%20new%20day.%20For%20example%2C%20from%20June%2015%2C%202019%20to%20today%2C%20at%20%241%2C000%20each%20day.%20Then%20update%20daily.%20Is%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582995%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20date%20computation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756332%22%20target%3D%22_blank%22%3E%40heatherjixf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20mean%3F%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.PNG%22%20style%3D%22width%3A%20411px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F211887i7B93019C12C513E4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22excel.PNG%22%20alt%3D%22excel.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, is there a way to compute a rolling date in an excel cell? Given a start date I want to calculate a daily value in a cell, that updates with each new day.

5 Replies
if you place a date in cell a1, =TODAY()-(A1) will give you a count from that date until today. You must format the formula with number or general format, not date format.
is there a way for it to calculate a new value each day? or would I have to enter in a date each day?

@heatherjixf

Not sure what you mean here. do you mean you want multiple dates? Could you attach an example? 

@Poogermum I want to compute a daily amount that updates with each new day. For example, from June 15, 2019 to today, at $1,000 each day. Then update daily. Is that possible?

@heatherjixf 

 

Hi,

 

Is this what you mean?

 

excel.PNG