| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function
On Monday, June 1, 2015 at 11:46:07 AM UTC+5:30, Claus Busch wrote:
hi again, Am Mon, 1 Jun 2015 08:04:30 +0200 schrieb Claus Busch: in C2 try: =IF(AND(EOMONTH($A2,-1)+1<=C$1,EOMONTH($B2,0)=C$1),"Yes","") better try this: =IF(AND(EOMONTH($A2,-1)+1<=C$1,$B2=C$1),"Yes","") Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional Hi Claus, This fixes my issue. Thanks a lot !! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
| Howw can I make a function return a date in date format | Excel Programming | |||
| Function Excel:If a Dateactual date create a RED alert in a cel? | Excel Programming | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Hybrid Mode
