04.10.2019

  1. smide

    Subtract dates

    Hello. In cell A1 I have current date created with formula =today() eg. 3-Oct-2019. In the same column starting from cell A3 (A3:A600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 04.10.2019 - 21:00). All those cells (A3:A600) are text cells. I need to subtract all those...
  2. smide

    Convert date to weekday name

    Hello. In column A (A1:A600) I have dates and time in format dd.mm.yyyy - hh:mm (ex. 04.10.2019 - 20:00 , there is one space between dd.mm.yyyy and '-' and one space between '-' and hh:mm). All those cells in column A are text cells. I need formula to convert those "dates" into weekday name...

Some videos you may like

This Week's Hot Topics

Top