Hi everyone,
I need to convert dates in the format YEAR.decimalpart into mm/dd/yyyy (e.g. 2007.15)
I have tried with DATE(YEAR(B25), MONTH(B25),DAY(B25)+C25*364.25) but I need more accurate results. The problem comes with the fact that we have leap years to take into account, so I need a formula that is OK with every any given year like 1985.something, 2000.something, etc.
Using 364.25 (365-1 if I use the 1st of January to start the count) gives an approximate date, but I need the exact date.
In B25 I have a date which is 1/1/2007 and in C25 I have the decimal part to be added like 0.85 or 0.50...
Thanks forward to everyone who will help.
Regards,
Deviad
Bookmarks