How to replace all F references to F1

[bananacitizen]

i wrote following formula =IF(AND(WEEKDAY(F1)>1,WEEKDAY(F1)<7),IF(AND(F1>=C10,F1<=D10),B10,""),"") and copied the formula from F10 to F18 . So all F references changed from F1 to F9. I want to replace all F references with F1 in each formula . Is there a way that I can do that without changing each formula individually. Many thanks for any advice.
Note: Once I changed cell reference to F1 I need to copy the formula across the rows so only F1 changes on cells on same rwo keeping all the other dell references constant

[6StringJazzer]

If you always want all formulas to refer to F1, then change the reference in the formula in F10 to be F$1 and then copy and paste it wherever you want it.

[bananacitizen]

Thanks for the suggestion. I actually did that. But it is time consuming if I have to paste on to 100 of cells. Just want to know whether there is a find and replace method or similar? Tried with a wild card but didnt work

[protonLeah]

If you change the F1's in the formula in F10 to F$1. Just double click the fill handle at the lower right corner of F10...

[6StringJazzer]

The formula in your post does not exist in the file you attached. I am unclear as to what the destination is for this formula. There might be a find & replace solution but I can't tell without more detail.

[Roel Jongman]

change your formula in F10 into

Please Login or Register  to view this content.

you can copy down and to the right all you want it will always gonna do a date compare to row 1 an col C and D and give value from col B when within timeframe.

I think you can replicate the same into the weekday part of your formula. (which is not in the file like already mentioned by 6StringJazzer
)

[bananacitizen]

Sorry not sure what happened. I re-attached again

[bananacitizen]

Thanks lot it worked. So simple. By the way is there anyway I can fix cell references in one operation for B,C,D from F10 to F18?

[AliGW]

If there are no other 10s in the formula other than the cell references, have you tried Find & Replace?

Find: 10
Replace: 18

[bananacitizen]

yes I tries, Cell reference B, C , D changes from B10 -B18 So find and replace doesnt work

[bananacitizen]

Awesome, Solved the problem taking into account all your responses. Grateful to all of you tried to help