Thread: Last workday
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mortir Mortir is offline
external usenet poster
 
Posts: 34
Default Last workday

How could i create a function that would aways show me last workday
before today? so for example:

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

tnx for your help