Suppose there is current date in A1 then to insert following Mondays date
based on current date, follow following steps
1.Select cell B1 right click formate cells number tabselect date from
category list select 03/14/01 from type list
2.Now insert following formula in cell B1
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+IF(WEEKDAY(A1)=1, 1,IF(WEEKDAY(A1)=2,0,IF
(WEEKDAY(A1)=3,6,IF(WEEKDAY(A1)=4,5,IF(WEEKDAY(A1) =5,4,IF(WEEKDAY(A1)=6,3)))))
))
Now you get it !
Have a nice day
Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com
--
Message posted via
http://www.officekb.com