Home |
Search |
Today's Posts |
|
#1
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
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
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
What formula do I use to add to a date column in Excel? | Excel Discussion (Misc queries) | |||
In Excel, I need a date math formula... | Excel Discussion (Misc queries) |