| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Thanks Tom - I meant to say on or before the 15th. How do I enter it? You've been a great help and time saver  "TomPl" wrote: > You did not indicate which way to go if the start date is the 15th. This > formula placed in cell C7 assumes that is the start date is the 15 it will be > due the following month: > =IF(ISBLANK(B7),"",IF(DAY(B2)<15,DATE(YEAR(B2),MONTH(B2),1),DATE(YEAR(B2),MONTH(B2)+1,1))) > > Pay them bills! > > "wf315" wrote: > > > Hello- > > > > My due date should be the 1st of the month if the start date is after the > > 15th or the 1st of the previous month if the start date is before the 15th, > > but only if there is an amt in B7 otherwise blank. > > > > > > B2=Start Date > > B7=Amt > > C7=Due Date |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Try this:
=IF(B7="","",EOMONTH(B2,(DAY(B2)>15)-1)+1) It required ATP add-ins "wf315" wrote: > > Thanks Tom - I meant to say on or before the 15th. How do I enter it? You've > been a great help and time saver > > > "TomPl" wrote: > > > You did not indicate which way to go if the start date is the 15th. This > > formula placed in cell C7 assumes that is the start date is the 15 it will be > > due the following month: > > =IF(ISBLANK(B7),"",IF(DAY(B2)<15,DATE(YEAR(B2),MONTH(B2),1),DATE(YEAR(B2),MONTH(B2)+1,1))) > > > > Pay them bills! > > > > "wf315" wrote: > > > > > Hello- > > > > > > My due date should be the 1st of the month if the start date is after the > > > 15th or the 1st of the previous month if the start date is before the 15th, > > > but only if there is an amt in B7 otherwise blank. > > > > > > > > > B2=Start Date > > > B7=Amt > > > C7=Due Date |
|
|
|
|
|||
|
Guest
Posts: n/a
|
In the formula I posted just change < 15 to <16.
Hope that helps "wf315" wrote: > > Thanks Tom - I meant to say on or before the 15th. How do I enter it? You've > been a great help and time saver > > > "TomPl" wrote: > > > You did not indicate which way to go if the start date is the 15th. This > > formula placed in cell C7 assumes that is the start date is the 15 it will be > > due the following month: > > =IF(ISBLANK(B7),"",IF(DAY(B2)<15,DATE(YEAR(B2),MONTH(B2),1),DATE(YEAR(B2),MONTH(B2)+1,1))) > > > > Pay them bills! > > > > "wf315" wrote: > > > > > Hello- > > > > > > My due date should be the 1st of the month if the start date is after the > > > 15th or the 1st of the previous month if the start date is before the 15th, > > > but only if there is an amt in B7 otherwise blank. > > > > > > > > > B2=Start Date > > > B7=Amt > > > C7=Due Date |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| date formula returns the 15th or the end of month | Steve | Microsoft Excel Worksheet Functions | 8 | 2nd Jan 2008 06:31 AM |
| If date in column A is less than 15th of month can I display next. | =?Utf-8?B?QW5nZWxh?= | Microsoft Excel Misc | 4 | 7th Nov 2007 02:40 PM |
| I want to format date cells for the 15th of every month.. | =?Utf-8?B?TWFnZ2ll?= | Microsoft Excel Programming | 1 | 24th Jul 2006 05:11 PM |
| 16th of Last Month to 15th of This Month... | ABAX | Microsoft Access Queries | 4 | 15th Jun 2006 03:52 PM |
| Formatting for 15th and last day of the month | Emilio Guerra | Microsoft Excel Worksheet Functions | 1 | 1st Dec 2005 03:14 PM |
