VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

**lynnsong986** · 10-23-2019, 02:58 PM

I found the solution, trying to delete the posting but couldn't...

**jolivanes** · 10-23-2019, 03:12 PM

Would you be so kind and show it for people searching for a solution for the same or similar problem.

**lynnsong986** · 10-23-2019, 03:16 PM

it's really just a basic formula

say I have a date
12/31/2018 in cell A1
and I want to turn it to 2018.12 as a number.
the formula would be:

=YEAR(A1)+Month(A1)/100

**jolivanes** · 10-23-2019, 03:49 PM

And the period (.) I assume
Thanks.
If it helps someone else, that will be nice.

**lynnsong986** · 10-23-2019, 03:56 PM

yea thanks so much for keeping this site going! it is truly great and I personally learnt so much from other people like you!

VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

LinkBack

Thread Tools

Rate This Thread

Display

Re: VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

Re: VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

Re: VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

Re: VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Cannot find date after 09.10.2019

Graphing Secondary Axis- Incorrect date (4/19/2019) alignment

[SOLVED] Correct exported date of 3/20/2019 to 3/1/2020

Introduction 7/23/2019

HMRC Apr 2019 bridging

Reflect TBF vacancies over 2018-2019/2019-2020 budget year

Converting text " 12/31/2019 to date format

Bookmarks

Bookmarks

Posting Permissions