Re: $$Excel-Macros$$ Date after weekend

2014-01-03 Thread Robinson Boreh
Dear Ravinder Thanks a lot. The formula seems so simple, if only i had used my head. Again, thanks. Regards, Boreh On 3 January 2014 13:01, Ravinder wrote: > =IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"),date_rng-2,date_rng > )) > > Or pfa > > > > > > *From:* excel-macr

RE: $$Excel-Macros$$ Date after weekend

2014-01-03 Thread Ravinder
=IF(TEXT(date_rng,"ddd")="SAT",C60-1,IF((TEXT(date_rng,"ddd")="SUN"), date_rng -2, date_rng)) Or pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Robinson Boreh Sent: Friday, January 03, 2014 3:25 PM To: excel-macros Subject: $$Excel-Macros$$ Date