View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default multiple formula

Hi All,

I have to provide a date for 2 variables

A1 will need 3 days added and A2 needs 2 days added

I have entered into A3 the following but need the formula for the 2 days
also in A3....I'm stuck

=IF(WEEKDAY(A1+3)=1,A1+5,IF(WEEKDAY(A1+3)=7,A1+6,A 1+3))

cheers Paul