Date Range formula for last date

Penelope Pitstop

Hi

I hope someone can help.   

I am trying to create a formula in Smartsheet that can pull the last date (i.e. the latest date) from a range of cells.  E.G.: I have x number of dates in a range of cells in column E and I want to create a formula to look at the range and show the last date in that range.  I must admit I am not a formula guru by any stretch of the imagination.

Any help would be greatly appreciated.

Shaine Greenwood

Hi Penelope,

I'd recommend checking out our article on creating and editing formulas, mainly so that you can become familiar with referencing cells in Smartsheet: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

If you're trying to find the latest date (closest to today), then use a MAX function. For example:

=MAX([Column E]:[Column E])

More on MAX in our help center: https://help.smartsheet.com/function/max

If you need to find the oldest date (furthest from today), then use MIN:

https://help.smartsheet.com/function/min

Penelope Pitstop

Shaine, PERFECT!!  Thank you very much and thank you for sharing the info on formulas.  Very much appreciated.

 

 

 

Katya

How to input that =max[ ] function for specific rows under a column?  For example, display the max date for column Actual Date in rows 19:27.   This would be input in a parent row. The sheet has a different set of dates (Start Date)  with dependencies applied.