# 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

#1
May 11, 2016 at 15:00:28
 What your looking for is the =DATEDIF() function.With your Start Date in cell A1and your End Date in cell B1put 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.MIKEhttp://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 ona regular basis here in the forums.Seems some people would rather we do their homework for them.MIKEmessage 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.MIKEhttp://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 •