Simple question for Excel users

%3CLINGO-SUB%20id%3D%22lingo-sub-2312749%22%20slang%3D%22en-US%22%3ESimple%20question%20for%20Excel%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312749%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20So%2C%20I%20am%20new%20to%20excel%20and%20basically%20know%20nothing.%20So%20please%20respond%20as%20if%20you%20giving%20a%20child%20instructions.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20document%2Fspreadsheet%20that%20will%20automatically%20fill%20in%20the%20next%20%22due%20date%22%20of%20an%20ongoing%20assignment.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20input%20the%20start%20date%20and%20have%20excel%20auto-populate%2090%20days%20out%20from%20that%20date%2C%20which%20would%20be%20the%20due%20date%20of%20the%20next%20plan.%3C%2FP%3E%3CP%3EI%20have%20been%20playing%20around%20and%20just%20can't%20seem%20to%20figure%20it%20out.%3C%2FP%3E%3CP%3EIt%20would%20be%20SUPER%20helpful%20if%20someone%20could%20briefly%20explain%2C%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20am%20on%20a%20regular%20Dell%20laptop.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20SO%20MUCH%20in%20advance!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313058%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20question%20for%20Excel%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042253%22%20target%3D%22_blank%22%3E%40Mandee04%3C%2FA%3E%26nbsp%3BIt%20can%20be%20as%20easy%20as%20in%20the%20picture%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-01%20at%2006.27.35.png%22%20style%3D%22width%3A%20255px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277212i520FE5DE0212AA2D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-01%20at%2006.27.35.png%22%20alt%3D%22Screenshot%202021-05-01%20at%2006.27.35.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20start%20date%20is%20in%20A1%20and%20B1%20contains%20a%20formula%20%3CSTRONG%3E%3DA1%2B90%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EBeware%20that%20the%20date%20in%20A1%20must%20be%20a%20%3CEM%3E%3CSTRONG%3Ereal%3C%2FSTRONG%3E%3C%2FEM%3E%20date%20that%20is%20recognised%20by%20Excel.%20Now%2C%20your%20laptop%20is%20probably%20set%20up%20to%20work%20with%20a%20date%20format%20that%20is%20commonly%20used%20in%20your%20region%2C%20US-style%20(m%2Fd%2Fy)%2C%20European-style%20(d%2Fm%2Fy)%20or%20ISO%20(y%2Fm%2Fd).%20When%20you%20do%20enter%20a%20date%20in%20the%20%22correct%22%20format%2C%20Excel%20will%20display%20it%20as%20you%20are%20used%20to%2C%20but%20in%20the%20background%20it%20has%20converted%20it%20to%20a%20number%2C%20counting%20the%20days%20from%20January%201%2C%201900.%20Hence%2C%20April%2030%2C%202021%20is%20day%20number%2044316.%20And%20because%20it's%20a%20number%20you%20can%20just%20add%2090%20to%20it%20to%20arrive%20at%20the%20due%20date.%20Excel%20knows%20you%20are%20working%20with%20dates%20a%20formats%20the%20value%20in%20B1%20as%20a%20date.%20But%20again%2C%20it%20actually%20is%20the%20number%2044406.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2317855%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20question%20for%20Excel%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2317855%22%20slang%3D%22en-US%22%3EThank%20you%20SO%20much!!!%20I%20really%20appreciate%20you%20taking%20the%20time%20to%20help%20me%20out%20with%20this!%3CBR%20%2F%3E1.%20Follow-up%20question...%3CBR%20%2F%3EIs%20there%20a%20way%20to%20make%20the%20forumal%20repeat%3F%20Or%20do%20I%20have%20to%20manually%20enter%20it%20in%20every%20time%3F%3CBR%20%2F%3EFor%20example%2C%20is%20there%20a%20way%20to%20put%20the%20current%20start%20dates%20under%20column%20A%20and%20have%20column%20B%20automatically%20add%20the%2090%20days%3F%3CBR%20%2F%3EOR%20no%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAgain%2C%20thank%20you%20so%20much%20for%20your%20time%20and%20consideration%20in%20responding%20and%20helping%20me%20with%20this!%20I%20greatly%20appreciate%20you!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! So, I am new to excel and basically know nothing. So please respond as if you giving a child instructions.

I am trying to create a document/spreadsheet that will automatically fill in the next "due date" of an ongoing assignment. 

I would like to input the start date and have excel auto-populate 90 days out from that date, which would be the due date of the next plan.

I have been playing around and just can't seem to figure it out.

It would be SUPER helpful if someone could briefly explain, please.

 

Also, I am on a regular Dell laptop. 

Thank you SO MUCH in advance! 

3 Replies

@Mandee04 It can be as easy as in the picture below.

Screenshot 2021-05-01 at 06.27.35.png

The start date is in A1 and B1 contains a formula =A1+90

Beware that the date in A1 must be a real date that is recognised by Excel. Now, your laptop is probably set up to work with a date format that is commonly used in your region, US-style (m/d/y), European-style (d/m/y) or ISO (y/m/d). When you do enter a date in the "correct" format, Excel will display it as you are used to, but in the background it has converted it to a number, counting the days from January 1, 1900. Hence, April 30, 2021 is day number 44316. And because it's a number you can just add 90 to it to arrive at the due date. Excel knows you are working with dates and formats the value in B1 as a date. But again, it actually is the number 44406.

Thank you SO much!!! I really appreciate you taking the time to help me out with this!
1. Follow-up question...
Is there a way to make the forumal repeat? Or do I have to manually enter it in every time?
For example, is there a way to put the current start dates under column A and have column B automatically add the 90 days?
OR no?

Again, thank you so much for your time and consideration in responding and helping me with this! I greatly appreciate you! @Riny_van_Eekelen

@Mandee04 Hover the mouse pointer over the small square in the bottom right-hand corner of the cell with the formula (B1). Click and hold and drag down as far as needed. In B2, it will say =A2+90, in B3 it will be =A3+90 etc.