| 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) | |||
Linear Mode
