| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with formula
Hi,
I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
With dates in column A, try this to find the latest:
=MAX(A:A) Format the cell as a date. You can use a specific range if you like: =MAX(A1:A100) Hope this helps. Pete On May 9, 3:09*pm, carol wrote: Hi, I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
Great thanks, that worked!
"Pete_UK" wrote: With dates in column A, try this to find the latest: =MAX(A:A) Format the cell as a date. You can use a specific range if you like: =MAX(A1:A100) Hope this helps. Pete On May 9, 3:09 pm, carol wrote: Hi, I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
You're welcome, Carol - thanks for feeding back.
Pete On May 9, 3:34*pm, carol wrote: Great thanks, that worked! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
=max(a2:a100)
format as date Assuming that your data is on a2:a100 range. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "carol" escreveu: Hi, I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
Great thanks, that worked!
"Marcelo" wrote: =max(a2:a100) format as date Assuming that your data is on a2:a100 range. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "carol" escreveu: Hi, I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with formula
thanks for the feedback
-- regards from Brazil Thanks in advance for your feedback. Marcelo "carol" escreveu: Great thanks, that worked! "Marcelo" wrote: =max(a2:a100) format as date Assuming that your data is on a2:a100 range. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "carol" escreveu: Hi, I need a formula that will serch an array of dates and generate the latest date in the cell. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
