Share via

How to add Static Date stamp using a formula not shortcut keys

Anonymous
2023-10-28T14:36:13+00:00

How to add Static Date stamp using a formula not shortcut keys

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-29T11:33:37+00:00

    Hi RY,

    Thanks for posting in the community. We're happy to help you.

    Regarding your query, please try the following formula, and then check if it meets your requirements or not. I assume you use the Excel desktop app. If not, please point it out and let us know.

    Let's say you want the static date stamp to be in B2.

    1. Change the Excel settings.

    Go to File> Options> Formulas, under "Calculation options", tick the option "Enable iterative calculation".

    1. Put the formula in B2. Select B2, set the cell format to "Date" and choose the related date format.

    =IF(A2<>"",IF(B2<>"",B2,NOW()),"")

    1. Enter anything in A1.

    We look forward to your response. Thanks for your cooperation.

    Sincerely,

    George | Microsoft Community Moderator

    3 people found this answer helpful.
    0 comments