Get instant live expert help on How do I calculate weeks from date
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Is there a formula to calculate the number of weeks between a hire date and a termination date?
Solved by A. D. in 26 mins
We have a spreadsheet to calculate storage in weeks, We have a date in Column, a date out column. We then need to calculate on a monthly basis how many weeks an item has been in storage during a month to calculate invoicing. We are needing a formula to work out this calculation line by line..
Solved by D. H. in 20 mins
I have a spreadsheet which has future 'eligable' dates entered into one of the columns. I need a formula to show that when it is 12 weeks from said date, it is flagged a colour. Then when it is 6 weeks from the eligable date it flags another colour.
for example:
name DOB eligibilty date
Joe Blogs 01/01/2001 01/01/2019
I would need the information to turn yellow 12 weeks before the eligibility date (so on 09/10/18) then red 6 weeks before the eligibility date (so on the 20/11/18). Is this possible?
Solved by M. H. in 16 mins
how to calculate days past due
from due date till todays date
Solved by F. S. in 28 mins
How to lock date reference so calendar populates, instead of moving weeks around.
Solved by A. H. in 27 mins