| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
THe Last DATE of the previous month from today
Sorry with the previous formula you don't need the date in A1 this one does
fererence a cell. =DATE(YEAR(A1),(MONTH(A1)-1)+1,0) "CmK" wrote: Hi I just what the last date from the preious month i am sure someone would of asked this prolbem beofore but nope I must be the first accountant to ask this thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| THe Last DATE of the previous month from today | Excel Worksheet Functions | |||
| Days in a month as of today | Excel Worksheet Functions | |||
| Date of the First day of the previous month | Excel Discussion (Misc queries) | |||
| 25 days previous to today? | Excel Discussion (Misc queries) | |||
| date of last friday of previous month | Excel Discussion (Misc queries) | |||
Threaded Mode
