Thread: Workday Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shannon Shannon is offline
external usenet poster
 
Posts: 53
Default Workday Formula

Hi,
I have the workday formula in one of my spreadsheets and it seems that just
recently it has stopped working and I cannot figure out why.
Cell A2: Users enter a date (dd/mm/yyyy)
Cell A3: Here is the WORKDAY formula

I want A3 to show the date 3 business days after A2. Now I have
=WORKDAY(A2,L3) where L3 refers to a cell with the number 3 in it. Used to
work, now it doesnt.

Any help would be wonderful.

Thanks!
Shannon