Quote:
Originally Posted by charlesdh
The cell shows "May 31 2018" if you look at the formula bar it shows 5/31/2018.
|
This indicates, that in cell is date, not date string. Format the cell as general for moment - you see a long integer value in cell. This is the real value stored there.
Quote:
Originally Posted by charlesdh
I'm using a string variable to get a date from another worksheet and then go to another worksheet and find the "Month" which is in row 2. The dates in this row are formate as "mmm-yyy". In the formula bar it will show 5/1/2018. And the row/column for this date shows "May-2018"
|
So on second sheet are also dates really?
Read Date from one sheet into variable as
Code:
YourVariable = FORMAT(YourDateOnSheet1,"yyyy-mm"))
On 2nd sheet, search for cell(s) where
Code:
FORMAT(YourDateOnSheet2,"yyyy-mm"))= YourVariable