Solved i am trying to enter a formula for less than 30 days 2 dates

May 11, 2016 at 13:43:54
Specs: Windows 7
I have 2 different dates in two cells using Excel
. the dates are past dates. I need a formula to tell me if the dates are less than 30 days apart.

See More: i am trying to enter a formula for less than 30 days 2 dates

Report •

#1
May 11, 2016 at 15:00:28
✔ Best Answer
What your looking for is the =DATEDIF() function.

With your Start Date in cell A1
and your End Date in cell B1
put this formula in cell C1

=DATEDIF(A1,B1,"D")

You can then wrap it in an IF() function like:

=IF(DATEDIF(A1,B1,"D")<30,"Less Than 30","Greater Than 30")

Also, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •

#2
May 11, 2016 at 19:18:17
Homework perhaps which should be done at home

Report •

#3
May 12, 2016 at 07:07:58
Ewen...Why respond if you are unable to provide a usable answer?

message edited by Jane1234


Report •

Related Solutions

#4
May 12, 2016 at 08:36:39
I believe that Ewen was simply voicing his opinion that the question asked
is very similar to a Homework question, which, believe it or not, we receive on
a regular basis here in the forums.
Seems some people would rather we do their homework for them.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#5
May 12, 2016 at 11:25:53
Believe me I am not doing homework. This was a legit question. I am self teaching for a project at work. I do not know all the ins and outs on how to use formulas yet and found this site and thought why not ask...

Report •

#6
May 12, 2016 at 13:09:31
I am self teaching for a project at work.
Not always an easy task.

If you have other question, please ask, but as I mentioned in my first reply,
Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •

#7
May 14, 2016 at 05:57:50
Thank you mmcconagy your reply mirrors mine word for word.

Regards

PS, My apologies Jane 1234 no offence was intended.

message edited by Ewen


Report •

Ask Question