Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2014, 08:11 AM
paulys paulys is offline how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28 Windows 7 32bit how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28 Office 2007
Novice
how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28


Assistance appreciated. How can I derive 31st March 2014 + 59 months = 28-2-2019 using formula
Reply With Quote
  #2  
Old 04-29-2014, 11:58 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28 Windows 7 64bit how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28 Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Hi try
Code:
=EDATE(A1,59)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Showing Revenue Recognition Based on Days and Months stratcat Excel 4 03-16-2014 10:09 AM
how can I find out 31/3/2014 + 59 months = 28/2/2019 by using a formula 28 Find & Replace formula for numbers? Griff Word 4 04-18-2011 02:47 AM
Setting up recurring months to skip some months etc. dwelch@ykfireprevention.c Outlook 0 11-30-2010 10:15 AM
Find duplicates formula hannu Excel 2 10-26-2010 02:48 AM
Needs help to find excel formula- Please aamer_1983 Excel 2 07-13-2009 01:46 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft