<div>
A date in Excel is actually a number, so 11/15/2014 is 41958.<br />
So when adding tomorrow 11/16/2014 (41959) the result is 83917 equal to the date 10/02/2129.<br />
Is that what you want?<br />
<br />
Please specify.<br />
A sample worksheet would help.
</div>


A date in Excel is actually a number, so 11/15/2014 is 41958.
So when adding tomorrow 11/16/2014 (41959) the result is 83917 equal to the date 10/02/2129.
Is that what you want?

Please specify.
A sample worksheet would help.

<div>
Are you looking to Sum the values or just get a count of the number of dates that meet the criteria? If you want a count, use this:<br />
<br />
=COUNTIF(L:L,&quot;&gt;=&quot;&amp;A1)<br />
<br />
Flyster
</div>


Are you looking to Sum the values or just get a count of the number of dates that meet the criteria? If you want a count, use this:

=COUNTIF(L:L,">="&A1)

Flyster

<div>
Assuming you want to extract dates from column L where it is greater than A1, in column M:<br />
<br />
=IF(INT(L2)&gt;=$A$1,INT(L2),<wbr />&quot;&quot;)<br />
<br />
Copy down column M as required.<br />
<br />
Thanks<br />
Rob H
</div>


Assuming you want to extract dates from column L where it is greater than A1, in column M:

=IF(INT(L2)>=$A$1,INT(L2),"")

Copy down column M as required.

Thanks
Rob H

<div>
@cansevin - I assume col M does not contain dates but includes values related to the date. <br />
<br />
If not, can I ask what you are achieving by adding up dates? As Ejgil pointed out, adding together dates just gives a larger number which represents a date further into the future.<br />
<br />
Thanks<br />
Rob H
</div>


@cansevin - I assume col M does not contain dates but includes values related to the date.

If not, can I ask what you are achieving by adding up dates? As Ejgil pointed out, adding together dates just gives a larger number which represents a date further into the future.

Thanks
Rob H

<div>
<div class="content wysiwyg-content">
I would like to do a sumif statement in excel that involves dates.<br />
<br />
Cell A1 has a date in the format 11/15/2014. Comunm L:L has dates in the format of date and time.<br />
<br />
If the date in greater than or equal to the date in A1 I want it to add the dates in column M.<br />
<br />
Any ideas on how to do that?
</div>
</div>


I would like to do a sumif statement in excel that involves dates.

Cell A1 has a date in the format 11/15/2014. Comunm L:L has dates in the format of date and time.

If the date in greater than or equal to the date in A1 I want it to add the dates in column M.

Any ideas on how to do that?

Sumif statement in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.