| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
looking for a date
i need a formula to display a date from a row of cells on a seperate page. it
needs to ignor all other dates except the last one in the row id appreciate help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
looking for a date
Hi Rich
With your dates in Sheet1 row 1 =TEXT(LOOKUP(9^99,Sheet1!$1:$1),"dd mmm yyyy") Change the Sheet location and row to suit, and choose whatever date format you want between the quotes -- Regards Roger Govier "Richdg" wrote in message ... i need a formula to display a date from a row of cells on a seperate page. it needs to ignor all other dates except the last one in the row id appreciate help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
looking for a date
"Roger Govier" wrote: Hi Rich With your dates in Sheet1 row 1 =TEXT(LOOKUP(9^99,Sheet1!$1:$1),"dd mmm yyyy") Change the Sheet location and row to suit, and choose whatever date format you want between the quotes -- Regards Roger Govier "Richdg" wrote in message ... i need a formula to display a date from a row of cells on a seperate page. it needs to ignor all other dates except the last one in the row id appreciate help thanks works perfectly |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
looking for a date
Your subject line indicates that you want E-Harmony.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Richdg" wrote in message ... i need a formula to display a date from a row of cells on a seperate page. it needs to ignor all other dates except the last one in the row id appreciate help |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
looking for a date
Hi,
Since you are looking at dates =LOOKUP(9^5,Sheet1!$1:$1) And then format the cell as needed. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Richdg" wrote: i need a formula to display a date from a row of cells on a seperate page. it needs to ignor all other dates except the last one in the row id appreciate help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Given a date, how do I get the 1st date and the last date of theprevious month? | Excel Worksheet Functions | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
