|
|
|
|
#1
03-15-2014, 02:01 PM
|
|||
|
|||
use this formula
=IF(OR($B2=DATEVALUE("31/12/2099"),AND(DAY($B2)>=15,OR(DATE(YEAR($B2),MONTH($B 2),DAY(1))>=DATE(YEAR(D$1),MONTH(D$1),DAY(1)),DATE (YEAR($B2),MONTH($B2)+1,DAY(1))=DATE(YEAR(D$1),MON TH(D$1),DAY(1)))),AND(DAY($B2)<15,DATE(YEAR($B2),M ONTH($B2),DAY(1))>=DATE(YEAR(D$1),MONTH(D$1),DAY(1 )))),0,$C2) 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula To Calculate Countdown Days To Project Completion
|
Catherine | Project | 1 | 02-19-2014 11:15 AM |
| Formula for week days only | gbaker | Excel | 5 | 02-15-2014 01:07 AM |
| showing calendar days by keeping normal workday calendar | ketanco | Project | 11 | 11-01-2013 08:27 AM |
|
Converting serial number to years, months and days
|
hannu | Excel | 6 | 02-14-2013 09:21 PM |
| Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode