| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date formula returns the 15th or the end of month
I have tried to develop a formula that returns the 15th of the month
(if today() is <= to the 15th) and the end of the month's date (if today() is greater than the 15th) I need it in the mm/dd/yy format. I have tried using text and "dd" with if statements but have not gotten it to work. I figure the end of month date could be handled with the EOMONTH(TODAY(),0) For January the dates would be either 01/15/08 or 01/31/08, Thanks for any help you can provide, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting for 15th and last day of the month | Excel Worksheet Functions | |||
| If date in column A is less than 15th of month can I display next. | Excel Discussion (Misc queries) | |||
| 15th of prior month | Excel Worksheet Functions | |||
| Function that returns the month name | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
Threaded Mode
