| 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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date
I dont think I get it all, but youo may use conditional functions together
with date functions.... =IF( dataChecked = dateNow, dateNow, EOMONTH( anyDayOfOtherMonth ,0)) "LWilson" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date
I'm just now getting back to this...I think this will work, but I'll check
and see. Thank you for your help! "Luizvs" wrote: I dont think I get it all, but youo may use conditional functions together with date functions.... =IF( dataChecked = dateNow, dateNow, EOMONTH( anyDayOfOtherMonth ,0)) "LWilson" wrote: 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!! |
| Reply |
| 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 | |||
Linear Mode
