Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Month Calculation

Hi,

Am Mon, 12 Nov 2012 19:17:18 +0000 schrieb Moideen:

Coloumn 1 (Invoice Date) : 05-07-2012

Coloumn 2 (Limit the Period) : 5

Coloumn 3 Need Result : 05-12-2012

try:
=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Month Calculation	Tony	Excel Worksheet Functions	4	July 17th 07 12:02 PM
Help!!! End of Month Calculation	Tony	Excel Worksheet Functions	4	February 16th 07 09:07 AM
Month end calculation	Tony	Excel Discussion (Misc queries)	2	March 23rd 06 01:24 AM
month-to-month calculation	Colin2u	Excel Discussion (Misc queries)	0	July 27th 05 01:32 AM
Month Calculation	Jamie[_6_]	Excel Programming	2	December 11th 03 08:18 PM

All times are GMT +1. The time now is 09:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us