| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date
I'm trying to write a formula so that if the date doesn't match, say the
current date, that it will take a month that I specify and give me the last day of that month. For example, the current date is 11/11/09. If the date doesn't match this date and I want to look at the last day of the month another month. Data is like this Jul 2009 Aug 2009 Sep 2009 Oct 2009 Nov 2009 In the July column, if the current date, specified by a cell in the worksheet is NOT= to Jul 2009 then return Jul 31, 2009, otherwise current date or 11/11/09 Help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Given a date, how do I get the 1st date and the last date of theprevious month? | Excel Worksheet Functions | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Threaded Mode
