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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |