Excel MT142 p1: Custom Number Format & Conditional Formatting for Dates & Weekends

[sumittailong]

Hi,

I require urgent help in solving my problem regarding my project in Excel 2007.

I hope you experts can help me getting instant solution to my problem.

______________________________­______________________________­__

For Ex:

Dispatch Date is 01/01/2011 (Saturday) & Delivery date which should be 4 days later from the dispatch date.

Here Sunday is not a working day. It has to be skipped during the count.

So please find me a solution/formula to solve this problem.

Thanks in advance!

Reply ASAP

[ExcelIsFun]

post questions to:

mrexcel[dot]com/forum

[arespinoza85]

i have a Q: is there a way to highlight dates that are for example 30 or 60 days past. I have to look throught several dates and mark when a client has been more than 30 late on paymente. is there a formula for this.

thanks

[ExcelIsFun]

Try this video:

Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due

[SanadFeisal]

Wow! This trick, if submitted by anyone working in an H.R. Dept., is a sure promotion.

[ExcelIsFun]

That is for sure! Knowing Excel has gotten me all my jobs!