Calculate no of days
Hi all ,
I have a query here in regard with date calculations
Lets say If I have two dates one is Quote date and a calendar week is given
ex: 09/06/2009 (MM/DD/YYYY) and Calender week is 48th.
If i am generating the task today then it should first find the difference between the quote date and Calender week
Next step should be, add this diiference value days to the current date and should give me the future working day
=DATE(YEAR(A1),1,B1*7-2)-WEEKDAY(DATE(YEAR(A1),1,3))
Will give you the date from the week number where A1 holds your quote date and B1 the week number.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
kamalthakur 
Register To Reply
Bookmarks