route217
asked on
date formula using network days
Hi Experts excel 2007
Need a date formula in cell c2 to do the following if cells a2 and b2 have date's.
If cell a2 has a date and b2 is blank the in c2 add 7 days
If cell b2 has date and a2 is blank the b2.nj
Need a date formula in cell c2 to do the following if cells a2 and b2 have date's.
If cell a2 has a date and b2 is blank the in c2 add 7 days
If cell b2 has date and a2 is blank the b2.nj
What do you mean by
the b2.nj
Regards
the b2.nj
Regards
ASKER
Hi itjockey
I have yo apologies. ...made an error...can we correct formula, please.
If a2 has a date and b2 is blank then a2 + 7 networkdays
If a2 is blank and b2 has a date then b2
Finally
If a2 has a date and b2 has a date then b2.
I have yo apologies. ...made an error...can we correct formula, please.
If a2 has a date and b2 is blank then a2 + 7 networkdays
If a2 is blank and b2 has a date then b2
Finally
If a2 has a date and b2 has a date then b2.
if you want to exclude weekend days in criteria 1 then use this
=TEXT(IF(AND(CELL("Format",A2)="D1",B2=""),A2+((7-(NETWORKDAYS(A2,A2+7)))+7),IF(AND(CELL("Format",B2)="D1",A2=""),B2,"")),"dd/mmm/yyyy")
ok give me one moment as I dint refresh browser ...your comment I see after I posted.
=TEXT(IF(AND(CELL("Format",A2)="D1",B2=""),A2+((7-(NETWORKDAYS(A2,A2+7)))+7),IF(AND(CELL("Format",B2)="D1",A2=""),B2,"")),"dd/mmm/yyyy")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
do u want me to combine condition 2 & 3 in one statement ?as both way outcome is B2.
Thanks
Thanks
ASKER
Excellence excellent. .
Thank You
Open in new window
Thanks