SOLVED

# insert date cell into formula as a cell Reference

Copper Contributor

# 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 many ways but nothing works

any suggestions

7 Replies

# Re: insert date cell into formula as a cell Reference

Can you please post one of the formulas that does not work?
best response confirmed by mathetes (Silver Contributor)
Solution

# Re: insert date cell into formula as a cell Reference

@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)

https://support.microsoft.com/en-us/office/create-a-named-range-from-selected-cells-in-a-worksheet-f...

# Re: insert date cell into formula as a cell Reference

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

# Re: insert date cell into formula as a cell Reference

@Marty927 Enter the date in any empty cell and name it "myDate". . Then replace "<=12/15/23" in the formula with "<=" & myDate

# Re: insert date cell into formula as a cell Reference

Thank you
The 2nd reply works great ("<="&Mydate) with my date as cell reference
Wish I knew this 3 years ago :):)

# Re: insert date cell into formula as a cell Reference

@Marty927 Glad you figured that out after 3 years. Could have come here sooner :)

# Re: insert date cell into formula as a cell Reference

I'm retired so it was a way to keep brain busy, until it became annoying
maybe next time
Thanks
1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution

# Re: insert date cell into formula as a cell Reference

@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)