Cell Value with a different number displaying

[fishewb]

Is there a way to have a cell value equal the "2019" and have this value used for formula calculation purposes but have the cell display "2020", even though it's value would be "2019"

Thank you

 

[kweaver]

Could you simply put 2020 in the cell and have your formula use that cell reference minus 1 in the calculations?

 

[Jack in the UK]

About all i can thing of without data is:

=INT(ROUNDDOWN(A1,0))

Change A1 to the target cell

Regards
jiuk

 

[fishewb]

Thank you for the suggestions. I tried something else that seems to work.

I changed the format to a custom format and typed "2020" in the display, it left 2019 as my value and formulas are still working fine.

 

[Rick Rothstein]

Thank you for the suggestions. I tried something else that seems to work.

I changed the format to a custom format and typed "2020" in the display, it left 2019 as my value and formulas are still working fine.

What will happen with this worksheet next year?

 

[fishewb]

What will happen with this worksheet next year?

Good point!

I am duct taping a model to quickly analyze/summarize data. We are doing a complete annual build of the model in a few months.

 

[fishewb]

About all i can thing of without data is:

=INT(ROUNDDOWN(A1,0))

Change A1 to the target cell

Regards
jiuk

Thanks for this option.

The model contains a basis tab that controls the header rows for approx 120 tabs. In each tab the model has lookups and calc cells that are driven by that 2019 date, that I'm looking to display 2020 as we transition to future view without historical data to use a as linked file yet.