Blog Archives

Tom’s Tutorials For Excel: Lookup Oldest and Newest Date

Tom’s Tutorials For Excel: Lookup Oldest and Newest Date

The picture shows one way of obtaining the oldest and newest dates in column B that correspond to the person’s name in column A that is in cell D2 as a lookup criteria. Because dates are numbers,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Count and Sum Between Dates

Tom’s Tutorials for Excel: Count and Sum Between Dates

In the picture, a table contains several columns of data, including a column of dates. Three examples show how you can perform various mathematical operations on multiple-column criteria between dates using the SUMPRODUCT function.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF

Tom’s Tutorials for Excel: How old are you? Undocumented DATEDIF.
Tom Urtis’ “Tom’s Tips for Excel” are being read so widely we are trying to share more of them, quick ones, longer ones & illustrated ones, each week. We welcome your comments & feedback. Do you prefer certain types of tips?

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,