Forum Discussion

sulekipel's avatar
sulekipel
Copper Contributor
Jan 20, 2022
Solved

Issues with Excel dates and sheets

Hi everyone,    I'm having two problems with the web version of excel that I haven't been able to find an answer to.   Problem 1: No matter what I do, when I drag the dates down to autofill days,...
Excel for web
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 20, 2022

    sulekipel 

    1) It fills correctly in my case

    Perhaps you have another regional settings, are you sure the entered 01/01/2022 is the date in your case, not text?

    2) To my knowledge is not implemented.

sulekipel's avatar
sulekipel
Copper Contributor
Jan 20, 2022

SergeiBaklan 

 

I'm sure that it is the date but am attaching screenshots just in case I'm missing something. I tried both US and UK regional settings also. 

 

Thanks for your response on the second question too.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 20, 2022

sulekipel 

I believe you have texts, not dates - values in column E are left aligned. You may check if enter in F15 (or so) formula =ISTEXT(E15).

 

Applying date format to the cell doesn't convert text to date (which is actually number), yo need to reenter it in your regional format or convert by formula, or by Text to Columns.

  • sulekipel's avatar
    sulekipel
    Copper Contributor
    Jan 22, 2022

    SergeiBaklan 

     

    Hello again 🙂 I see that they were texts and I converted them with the text to columns in the data section and it worked.

     

    Thank you so much for your help!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 22, 2022

      sulekipel , you are welcome, glad to help

Resources