Excel Tips - Create Checkboxes to Format Cells and Insert Current Date and Time

Поделиться
HTML-код
  • Опубликовано: 25 янв 2025

Комментарии • 12

  • @lezamnukwa8328
    @lezamnukwa8328 10 месяцев назад +1

    This is very helpful. Good Job

  • @sunilsomanath623
    @sunilsomanath623 Год назад +1

    Very nice 👍👌

  • @CessM19
    @CessM19 2 месяца назад +1

    Thank you very much! I have a question, what happens if I open this Excel tomorrow? The date will change?

    • @CareerSolutionsforToday
      @CareerSolutionsforToday  2 месяца назад +1

      @@CessM19 Hey there, if you follow the instructions in the video the date shouldn't change.

  • @modigg07
    @modigg07 Месяц назад +1

    How do you change the format to date and time?

    • @CareerSolutionsforToday
      @CareerSolutionsforToday  Месяц назад

      Hey there, just use the format dropdown in the Number section of the home tab. It should be near the middle of the Excel screen.

  • @ssaannya
    @ssaannya Месяц назад +1

    why does it give an error when the formula '=IF(B2=TRUE,IF(C2"",C2,Now()),"")' is entered

    • @CareerSolutionsforToday
      @CareerSolutionsforToday  Месяц назад +1

      Hey there, did you remember to enable iterative calculations as well?

    • @ssaannya
      @ssaannya Месяц назад +1

      @@CareerSolutionsforToday ,yes i found the reason. the problem was in "," I put ";" everywhere the stiffness of the coma and the formula worked.
      Thank you very much. Thank you for your content and for your reply

    • @CareerSolutionsforToday
      @CareerSolutionsforToday  Месяц назад +1

      @@ssaannya Thank you as well =)