Forum Discussion
Solved
insert date cell into formula as a cell Reference
i want to use cell with date,ex. (12/12/2023),in many formulas and do not want to type it over again, as they may be referenced many time in each formula I have tried using , (= cell reference) in ...
Marty927 Give the cell with 'the date' a name like "myDate". Then you can reference to that name in any formula without having to worry about the actual cell reference where the date sits.
So you could just enter =myDate and the date will pop up. Or =IF(A1> myDate, 1, 2)
More about named ranges here:
Can you please post one of the formulas that does not work?
I removed the leading=
IF(C572<=NOW(),"",(SUMIFS('Open Positions'!$E$3:$E$191,'Open Positions'!$B$3:$B$191,A572,'Open Positions'!$A$3:$A$191,"<=12/15/23"))*E572)
For clarity I want to make 12/15/23 a cell reference, in this case B572 as is A572 and E572
IF(C572<=NOW(),"",(SUMIFS('Open Positions'!$E$3:$E$191,'Open Positions'!$B$3:$B$191,A572,'Open Positions'!$A$3:$A$191,"<=12/15/23"))*E572)
For clarity I want to make 12/15/23 a cell reference, in this case B572 as is A572 and E572
Marty927 Enter the date in any empty cell and name it "myDate". . Then replace "<=12/15/23" in the formula with "<=" & myDate