Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goto specified date
Hi everyone,
I'm using Excel 2003 and trying to use Windows Find to got to a cell containing a specified date. C3 is the 1st date in the worksheet and all other dates are calculated from this date. C: is formatted custom dd-mmm-yy and B: is formatted custom dddd to show day of the week. I've tried reformatting to Date but this does not seem to make any difference. Could anybody help me to find a way to goto specified dates as a way of navigating through the worksheet? Many thanks -- Deirdre |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goto specified date
When you choose CTRL+F and you are trying to find a calculated Date, you need
to type in the date as it would be in the format, i.e.: 04-Apr-08, and the 3rd pull down menu, change Look in: option to Values. -- John C "Diddy" wrote: Hi everyone, I'm using Excel 2003 and trying to use Windows Find to got to a cell containing a specified date. C3 is the 1st date in the worksheet and all other dates are calculated from this date. C: is formatted custom dd-mmm-yy and B: is formatted custom dddd to show day of the week. I've tried reformatting to Date but this does not seem to make any difference. Could anybody help me to find a way to goto specified dates as a way of navigating through the worksheet? Many thanks -- Deirdre |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goto specified date
That does the trick :-)
Many thanks -- Deirdre "John C" wrote: When you choose CTRL+F and you are trying to find a calculated Date, you need to type in the date as it would be in the format, i.e.: 04-Apr-08, and the 3rd pull down menu, change Look in: option to Values. -- John C "Diddy" wrote: Hi everyone, I'm using Excel 2003 and trying to use Windows Find to got to a cell containing a specified date. C3 is the 1st date in the worksheet and all other dates are calculated from this date. C: is formatted custom dd-mmm-yy and B: is formatted custom dddd to show day of the week. I've tried reformatting to Date but this does not seem to make any difference. Could anybody help me to find a way to goto specified dates as a way of navigating through the worksheet? Many thanks -- Deirdre |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Goto specified date
Thanks for the feedback. don't forget to check the box :)
-- John C "Diddy" wrote: That does the trick :-) Many thanks -- Deirdre "John C" wrote: When you choose CTRL+F and you are trying to find a calculated Date, you need to type in the date as it would be in the format, i.e.: 04-Apr-08, and the 3rd pull down menu, change Look in: option to Values. -- John C "Diddy" wrote: Hi everyone, I'm using Excel 2003 and trying to use Windows Find to got to a cell containing a specified date. C3 is the 1st date in the worksheet and all other dates are calculated from this date. C: is formatted custom dd-mmm-yy and B: is formatted custom dddd to show day of the week. I've tried reformatting to Date but this does not seem to make any difference. Could anybody help me to find a way to goto specified dates as a way of navigating through the worksheet? Many thanks -- Deirdre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goto or Find a Date in a Sheet | Excel Discussion (Misc queries) | |||
How to automatically goto to today's date | Excel Worksheet Functions | |||
Goto code | Excel Discussion (Misc queries) | |||
Subtract # of days from date, but if not sat, goto previous sat? | Excel Discussion (Misc queries) | |||
If.....Then GoTo....... | Excel Discussion (Misc queries) |