| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last day of last month
Hello,
In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Thanks for the help Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last day of last month
Try this...
A1 = 9/20/2009 =A1-DAY(A1) -- Biff Microsoft Excel MVP "Jim" wrote in message ... Hello, In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Thanks for the help Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last day of last month
Try
=DATE(YEAR(A1),MONTH(A1),0) If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: Hello, In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Thanks for the help Jim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last day of last month
In cell A1 I will have the due date of a bill. For this example let's
call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Here's one way in Excel 2003: =EOMONTH(A1,-1) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last day of last month
=DATE(YEAR(TODAY()),MONTH(TODAY()),0)
works on Excel 2003 if you don't want to reference another cell w/ a date. "Jim" wrote: Hello, In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Thanks for the help Jim |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last day of last month
Another one:
=today()-day(today()) (format as a date) Longaberger_lover wrote: =DATE(YEAR(TODAY()),MONTH(TODAY()),0) works on Excel 2003 if you don't want to reference another cell w/ a date. "Jim" wrote: Hello, In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the previous month, in this case August 31, 2009. Thanks for the help Jim -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
