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

Mark Forums Read

Thread Tools

Display Modes

06-09-2017, 06:55 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

WooHoo, forget my follow up questions, your formula worked perfectly and as written it automatically determined the correct cycle.

Thank you for sharing your expertise.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 12:28 AM.