| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
THe Last DATE of the previous month from today
=DATE(YEAR(NOW()),(MONTH(NOW())-1)+1,0)
with todays date in A1 try "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 | |||
| Days in a month as of today | Excel Worksheet Functions | |||
| conditional format for if month(today) = xxx | 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
