| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a date formula
Hi Folks,
I would really appreciate help with this. I need a formula for the date that is the last day of the month three months ago. E.g. if today is 28th Feb 2009, I want to return 30th Nov 2008. So maybe someone could construct the formula for me with 28th Feb 2009 in cell A1. Many thanks, probably a lot easier than it seems to me right now. Andrew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a date formula
Thanks a lot Mike, I knew it would be straightforward
Andrew "Mike H" wrote in message ... Hi, =eomonth(TODAY(),-3) If you get a #NAME error then Tools|Addins - Select the analysis toolpak Re-Enter the formula Mike "Andrew Mackenzie" wrote: Hi Folks, I would really appreciate help with this. I need a formula for the date that is the last day of the month three months ago. E.g. if today is 28th Feb 2009, I want to return 30th Nov 2008. So maybe someone could construct the formula for me with 28th Feb 2009 in cell A1. Many thanks, probably a lot easier than it seems to me right now. Andrew |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a date formula
Hi,
=eomonth(TODAY(),-3) If you get a #NAME error then Tools|Addins - Select the analysis toolpak Re-Enter the formula Mike "Andrew Mackenzie" wrote: Hi Folks, I would really appreciate help with this. I need a formula for the date that is the last day of the month three months ago. E.g. if today is 28th Feb 2009, I want to return 30th Nov 2008. So maybe someone could construct the formula for me with 28th Feb 2009 in cell A1. Many thanks, probably a lot easier than it seems to me right now. Andrew |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a date formula
In case you don't have the analysis toolpak
=DATE(YEAR(TODAY()), MONTH(TODAY())-2, 0) Mike "Mike H" wrote: Hi, =eomonth(TODAY(),-3) If you get a #NAME error then Tools|Addins - Select the analysis toolpak Re-Enter the formula Mike "Andrew Mackenzie" wrote: Hi Folks, I would really appreciate help with this. I need a formula for the date that is the last day of the month three months ago. E.g. if today is 28th Feb 2009, I want to return 30th Nov 2008. So maybe someone could construct the formula for me with 28th Feb 2009 in cell A1. Many thanks, probably a lot easier than it seems to me right now. Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Linear Mode
