Forum Discussion

Copper Contributor

Nov 02, 2023

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 ...

Formulas and Functions

Riny_van_Eekelen
Nov 02, 2023
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:
https://support.microsoft.com/en-us/office/create-a-named-range-from-selected-cells-in-a-worksheet-fd8905ed-1130-4cca-9bb0-ad02b7e594fd

Riny_van_Eekelen

Platinum Contributor

Nov 02, 2023

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:

https://support.microsoft.com/en-us/office/create-a-named-range-from-selected-cells-in-a-worksheet-fd8905ed-1130-4cca-9bb0-ad02b7e594fd

Marty927
Copper Contributor
Nov 02, 2023
Thank you
The 2nd reply works great ("<="&Mydate) with my date as cell reference
Wish I knew this 3 years ago :):)
- Riny_van_Eekelen
  Platinum Contributor
  Nov 02, 2023
  Marty927 Glad you figured that out after 3 years. Could have come here sooner 🙂
  - Marty927
    Copper Contributor
    Nov 02, 2023
    I'm retired so it was a way to keep brain busy, until it became annoying
    maybe next time
    Thanks