Hi,
I have created an adapted notation type of cel properties of yyyy-m (2019-01) for each date in a column. However, i see that the underlying value is still mm-dd-yyyy (01-12-2019). I would like the cell values to be equal to the notation type of the dates. Is this possible?
Any input is welcome!
Thank you in advance.
Last edited by MaartenRo; 06-16-2020 at 07:22 AM.
Cell formatting is only what XL shows. In the background, dates and times are numbers. If you want to change them to a certain format definitively try =TEXT(A1,"yyyy-m").
Of course if you then need to do anything with those dates in formulas or anything, you are in trouble..
Thank you for your input. I am trying to create a macro that places the dates of one column as a text in another column, so i can use this for a SumIf function as a condition.
But my macro doesn't work:
Is there a way to do this?
Please Login or Register to view this content.
The problem is the line "Range("H" & i).Value .......
Thank you for your input Arthurbr!
The macro with the formula is to complicated and using your function works fine.
How does placing a date which is merely a string of text help you when you want to use arithmetic to analyse the strings of text. You need the date number to do that.
What do you mean by the formula is too complicated. What is the formula?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks