Cell Needs Latest Date from SAME Column

[samsilverman]

Is there a way for a cell to compute the latest date from other cells in the same column? This is so a fuel charge will always be activated by the latest date a client is serviced. I can get the techs to manually input the date, but would rather have it automated.

Thanks for any help.

 

[repairman615]

Hello,

There is a =Now() or a =TODAY() function. These will be updated as a variable or in other words, not a constant.

 

[jasonb75]

Maybe something like

=MAX(A1:A100)

 

[samsilverman]

Hello,

There is a =Now() or a =TODAY() function. These will be updated as a variable or in other words, not a constant.

Well, it needs to pick up the latest date that was input by the technician. That would not necessarily be today's date. If he completes the paperwork on January 22, 2011 it could be for areas he serviced on January 15, 2011.

Maybe something like

=MAX(A1:A100)

The cell may be within the range it is looking through. So, in your example, it may be A30 that needs to find the latest input date in Column A.

 

[jasonb75]

So what action should cause the cell to update? Selecting the cell, filling in an adjacent cell? Something else?

 

[samsilverman]

Let's say rows 7 through 25 are for different service areas. On the latest visit (January 20), only rows 12-15 get a new date placed in Column E because those are the only areas that are serviced.

Row 26 is reserved for a fuel charge. That row's cell for column E would pick up the latest date of January 20th through some type of formula or macro.

 

[jasonb75]

Based on that

=MAX(E7:E25) in E26 would pick up the latest date.