Related:
- Calculating dates with some conditions
- Calculating 8 processors excel - Guide
- Formula for calculating position in excel - Office Software Forum
- If cell contains text then return value multiple conditions - Excel Forum
- Excel save without calculating - Guide
- Adjust videos to network conditions facebook - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 12, 2011 at 07:28 AM
Jun 12, 2011 at 07:28 AM
Even though you did explain a lot and provided a sample sheet, i am still having a hard time understanding. Are you basically looking to find number of days between two days and exclude any holidays, I have a feeling you would need to use NETWORKDAYS function in some way to get to what you want. For other part you can lock the cells by protecting the sheet
Jun 12, 2011 at 11:24 PM
Thank you for your reply.
I am sorry that i made some mistake while explaining.
I want to find the date for the following,
D-1 , D-5 , D-9 , D-11 , D-30.
Here D is today's date.
(-) is minus symbol.
D-1 is yesterday's date.
D-5 ---> Date before 5 days from today's date, calculating from yesterday's date.
Same way for D-11 and D-30.
Could you please find the below link. one example has been worked.
http://www.speedyshare.com/files/28912864/Date_calculation.xls.
I hope this clear now.
Thank you.
Jun 18, 2011 at 03:01 AM
Use this link for excel worked example.
http://www.speedyshare.com/files/29027444/Date_calculation.xls