Thread: Last workday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Last workday

Hello,

Am Wed, 15 Jun 2011 03:57:05 -0700 (PDT) schrieb Mortir:

1.today is wednesday 15 jun. So the function would show: tuesday 14
jun
2. today is monday 13 jun and the funtion would show: friday 10 jun


your date in A1. Then try:
=A1-CHOOSE(WEEKDAY(A1),2,3,1,1,1,1,1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2