converting a return of days in a formula to year 1, 2, 3 ect.

		Microsoft Office Forums > Microsoft Excel > Excel
converting a return of days in a formula to year 1, 2, 3 ect.

FAQ

Thread Tools

Display Modes

06-09-2017, 06:52 AM

bonth123

Windows 7 64bit converting a return of days in a formula to year 1, 2, 3 ect.

Office 2007

Novice

Join Date: Jun 2017

Posts: 3

Thanks for the help, I have two follow up questions, did your formula mean to say I2, not I1? also, how would I continue the number for each consecutive year? These will end up going out to a 5 year range.

Thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM
Formula for week days only	gbaker	Excel	5	02-15-2014 01:07 AM
Formula to count entries as per month, year and submission wise from different sheets	pinkacidpunk	Excel	1	05-28-2013 08:26 AM
Converting serial number to years, months and days	hannu	Excel	6	02-14-2013 09:21 PM
Formula to calculate Leap Year	USAOz	Excel	2	09-11-2011 04:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:35 PM.