Solved What is the excel formula in computing the number of days?

July 26, 2018 at 19:33:25
Specs: Windows 10
Hi! I am trying to find an excel formula that will allow me to count the number of days from the starting date.

for example: the customer ordered from us today, then he was given a 30days term. What will be the excel formula for this, that could show me if he exceeds from the term given to him. Thanks :-)


See More: What is the excel formula in computing the number of days?

Reply ↓  Report •

#1
July 26, 2018 at 22:53:44
✔ Best Answer
Not completely sure what you want, but simply adding 30 days to your initial date should work.

With today's Date in cell A1, IE 07/27/2016
Term in days in cell B1, IE 30
In cell C1 enter the formula: =B1+A1

      A         B          C
1) 7/27/2018	30	8/26/2018


Make sure cell C1 is formatted as a Date Cell
Is that what your looking for?

You might also what to look at these two HOW-TO'S
which use Conditional Formatting for Past Due Dates and Deadline Dates.

https://www.computing.net/howtos/sh...

https://www.computing.net/howtos/sh...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •

#2
July 30, 2018 at 22:50:59
Ok. I got it. Thanks for the help ;)

Reply ↓  Report •
Related Solutions


Ask Question