Hi guysTrying to calculate =edate in excelI have the following set up;(I need to show a run of 10 week dates)A101-SEPT-09A201-NOV-09 =EDATE(a1,2) to show 2 months after 01-sept-09How do I make A3 to show 10 weeks after A2ThanksNeil.
If you want to show periods 10 weeks apart, the easiest option is to put the first date in A1.Highlight down as many times as you need.Go to EDIT , Fill, Series, in the box enter 70 (10 x 7 days), OKdone
Thank you bothAs easy as that..... Much appreciatedNeil.
This thread is now locked and can not be replied to.
OnePlus 5 review
50 best online Adobe XD tutorials
iPad Pro 10.5in (2017) review
Comment connecter un MacBook à une TV ?
© Copyright 2017 IDG UK. All Rights Reserved.