Date value for dates beyond 1990

Question

Hi

Excel has limit in date range i.e. it does not work with date beyond 1990 when i want to have date value between two dates lets say between 12/01/1396 and 12/02/1398. Does anyone know how to get the date value in such case?

Thanks

Akram

Answer 1

Akramul,

Just for information (if you are proficient at VBA), VBA is a separate product and does not use the Excel Date algorithms.  In VBA, a data variable can represent dates between:  January 1, 100 to December 31, 9999

So you could always build your own User Defined Function in VBA if you have those skills.   I would guess that is what John Walkenbach has done in his Addin. 

--

Regards,

Tom Ogilvy

Answer 2

Re:  dates before 1900

You can insert older dates (as text) with my free date picker ("Get Your Own Date").

(excel add-in for xl97 thru xl2010 only)

Down load from... https://goo.gl/IUQUN2 (Dropbox)

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 3

John Walkenbach has created an Excel addin that provides functions to work with such "dates" 

http://spreadsheetpage.com/index.php/tip/extended\_date\_functions/

--

Regards,

Tom Ogilvy