| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
