Hi there, can somebody help me out please?
Here's the scenario;
A1 = input date1 (earlier date)
A2 = input date2 (current or later date)
A3 = number of weeks between the above 2 dates
Thank you in advance
Hi there, can somebody help me out please?
Here's the scenario;
A1 = input date1 (earlier date)
A2 = input date2 (current or later date)
A3 = number of weeks between the above 2 dates
Thank you in advance
Hi fox,
Try:
=(A2-A1)/7
Or if you want a whole number of weeks, with no remainder:
=INT((A2-A1)/7)
quickbrwnfox
Have a look at this link that explains how to use Datedif function
http://www.cpearson.com/excel/datedif.aspx
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks