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 :-)

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+A1A 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

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Do you think its a good idea for Amazon to divide its new second headquarters between two locations?

Discuss in The Lounge

Poll History