[Solved] Find date in column

[Cat101]

I have a simple spreadsheet, that will be for an entire year. The individual who sets schedules need to easily find a date within it, to note the schedule. Sometimes she's scheduling 3-4 months out.

The date is set only with 1/1/24 (in cell A1) & after that, date is just A1+1.
Do i need to change it to TEXT to find it & yes, [CTRL}F? or suggestion?

See attached

[FJCC]

You can find the dates in column A using the full Find & Replace dialog. You can bring that up with Ctrl + F or the binocular icon on the main tool bar. Click More Options and, near the bottom of the dialog, set Search In to Values. You can then search for 05/04/24 and it will find it. The setting to Values seems to be remembered, so you won't have to set that one every search, probably just once per session. The default is to look in Formulas and, of course, 05/04/24 does not appear in any of your formulas.

[Cat101]

Hummmm...I've never done that.. But it does work, and your right, once set it works next time..

Now to remember that when the user messes with it.. LOL

THANKS!

[robleyd]

The date is set only with 1/1/24 (in cell A1) & after that, date is just A1+1.

To keep the date as a value, you can enter the start date - as you have done - then drag the value down as far as needed using the drag handle on the bottom right of the cell.

The drag handle

aoo_drag01.png (13.81 KiB) Viewed 451 times

Your cursor will change to a cross hair as you move it over the handle; just click and drag as needed.

Cursor changes to cross hair

aoo_drag02.png (13.31 KiB) Viewed 451 times

[Alex1]

The day of the week can be shown in the same cell as the date by adding NN or NNN to the format, making column B superfluous.

[Cat101]

Thanks for the input...