|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 6th, 2006, 10:46 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to add 6 months to a certain date in a formula (Excel)
I need to calculate 6 months (for example) starting from a certain date (not
TODAY)... 
|
|
#2
July 6th, 2006, 11:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to add 6 months to a certain date in a formula (Excel)
One way.
With starting date in A1, try this: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Joana" wrote in message ... I need to calculate 6 months (for example) starting from a certain date (not TODAY)...
|
|
#3
July 6th, 2006, 11:27 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to add 6 months to a certain date in a formula (Excel)
=MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}))
this caters for 31st March not returning 1st October but 30th September. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Joana" wrote in message ... I need to calculate 6 months (for example) starting from a certain date (not TODAY)...
|
|
#4
July 6th, 2006, 12:21 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to add 6 months to a certain date in a formula (Excel)
Now ... why didn't I think of that?g
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Bob Phillips" wrote in message ... =MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1})) this caters for 31st March not returning 1st October but 30th September. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Joana" wrote in message ... I need to calculate 6 months (for example) starting from a certain date (not TODAY)...
|
|
#5
July 6th, 2006, 02:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want to add 6 months to a certain date in a formula (Excel)
On Thu, 6 Jul 2006 11:27:08 +0100, "Bob Phillips"
wrote: =MIN(DATE(YEAR(A1),MONTH(A1)+{7,6},DAY(A1)*{0,1}) ) Verry nice. Finally, a concise substitute for the EDATE ATP function. --ron
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I write an excel formula to display the file save date? | Bob-123456789 | Worksheet Functions | 1 | January 26th, 2006 07:50 PM |
| Showing today’s date when the Excel value is zero | David Hall | Mailmerge | 7 | January 9th, 2006 11:28 AM |
| Adding info to query | mjj4golf | Running & Setting Up Queries | 20 | January 9th, 2006 02:29 AM |
| Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
| Imported Date & Time format with calcs. managed in excel from imrp | Todd F. | Worksheet Functions | 0 | July 8th, 2005 09:03 PM |
Linear Mode
