dynamic number of days

[snking]

Hello everyone,

I am trying to make an excel spreadsheet that will do a couple of things. The first is it will tell me how many days have passed since a specific date. For example, if B2 is 1/24/2019, then C2 (which is where I want the number to be) will be a dynamic number that goes up by one as each day pass. So on 1/25/2019, C2 will have the number 1 in it. And on 1/26/2019, it will be 2, and it will go on from there. D2 and E2 would have the same relationship as C2 and D2. Meaning I need for E2 to tell me how many days based on D2. I would need to duplicate this formula all the down to M2 and N2. This will tell me how many days since I serviced a customers' property (column C) and what is the next approximate service date (column D). I hope this makes sense, I know nothing of how to create formulas in excel. Thanks in advance for any help...

S.

 

[Yongle]

I do not follow some of your explanation, so here is an explanation to help you create your own formulas
Some formatting occurs automatically, but sometimes you must do yourself by Right-Clicking on cell \ Format Cells \ etc

C2
formula
=TODAY()-B2
format C2 as a NUMBER with no decimal places

D2
If next service is due in 45 days, calculate the next sevice date like this
=B2+45
format D2 as date

To work out how many days to the next service, where D2 contains next service date
E2
formula
=D2-TODAY()
format E2 as a NUMBER with no decimal places

F2
If next service is due in a further 45 days, copy cell D2 and paste in F2
or enter the formula manually
=D2+45
If next service is NOT due in 45 days, then replace the 45 with the appropriate number
format F2 as date

G2
Copy cell E2 and paste in G2
or enter the formula manually
=F2-TODAY()
format G2 as a NUMBER with no decimal places

 

[snking]

Hey Yougle,

Thanks for the response. I'm going to try to create a formula based on what you have told me. Hopefully, it will work, thanks again.


Shawn,

I do not follow some of your explanation, so here is an explanation to help you create your own formulas
Some formatting occurs automatically, but sometimes you must do yourself by Right-Clicking on cell \ Format Cells \ etc

C2
formula
=TODAY()-B2
format C2 as a NUMBER with no decimal places

D2
If next service is due in 45 days, calculate the next sevice date like this
=B2+45
format D2 as date

To work out how many days to the next service, where D2 contains next service date
E2
formula
=D2-TODAY()
format E2 as a NUMBER with no decimal places

F2
If next service is due in a further 45 days, copy cell D2 and paste in F2
or enter the formula manually
=D2+45
If next service is NOT due in 45 days, then replace the 45 with the appropriate number
format F2 as date

G2
Copy cell E2 and paste in G2
or enter the formula manually
=F2-TODAY()
format G2 as a NUMBER with no decimal places

 

[snking]

Hey Yongle,

Thanks again for the formulas, they worked like a charm. I really appreciate all your help and everyone at Mr.Excell.....

Shawn,

 

[Yongle]

thanks for the feedback