| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract 6 months
I would like to create a formula that will subtract 6 months from today's
date. What function can I use for this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 6 months
Well, here is the quick and dirty.
=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())) Hopefully someone has a more elegant solution. Lynn wrote: I would like to create a formula that will subtract 6 months from today's date. What function can I use for this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 6 months
=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570771 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 6 months
thanks - this will work!
"Thufir Howat" wrote: Well, here is the quick and dirty. =DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())) Hopefully someone has a more elegant solution. Lynn wrote: I would like to create a formula that will subtract 6 months from today's date. What function can I use for this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract 6 months
=EDATE(TODAY(),-6)
which requires the Analysis Toolpak to be installed. If today is 8/31/06, the other formula will return 2/31/06 which excel will interpret as 3/3/06. I assume you would want 2/28/06? "Lynn" wrote: thanks - this will work! "Thufir Howat" wrote: Well, here is the quick and dirty. =DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())) Hopefully someone has a more elegant solution. Lynn wrote: I would like to create a formula that will subtract 6 months from today's date. What function can I use for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS? | Excel Worksheet Functions | |||
| Subtract MM/DD/YYYY and get # months | Excel Discussion (Misc queries) | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
| I want to subtract 2 dates and display the result as months | Excel Worksheet Functions | |||
Linear Mode
