Auto Populate Data based on Start & End Date

%3CLINGO-SUB%20id%3D%22lingo-sub-2257512%22%20slang%3D%22en-US%22%3EAuto%20Populate%20Data%20based%20on%20Start%20%26amp%3B%20End%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257512%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(AND(K%242%26gt%3B%3D%24G255%2CK%242%26lt%3B%3D%24H255)%2C%24I255%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20current%20formula%20above%2C%20I%20have%20to%20enter%20the%20%22End%20Date%22%20in%20order%20for%20it%20to%20populate.%20I%20would%20like%20for%20it%20populate%20when%20the%20End%20Date%20is%20blank%2C%20then%20once%20the%20End%20Date%20is%20entered%20it%20would%20true%20it%20up%20to%20that%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CURTISSHORT_1-1617742169655.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F270607i54FEEFFEE53B99C0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22CURTISSHORT_1-1617742169655.png%22%20alt%3D%22CURTISSHORT_1-1617742169655.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CURTISSHORT_0-1617742241510.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F270608iD4D026628D22EB0A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CURTISSHORT_0-1617742241510.png%22%20alt%3D%22CURTISSHORT_0-1617742241510.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2257512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2258859%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Populate%20Data%20based%20on%20Start%20%26amp%3B%20End%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2258859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1018696%22%20target%3D%22_blank%22%3E%40CURTISSHORT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMay%20I%20suggest%20that%20you%20attach%20not%20an%20image%20but%20a%20copy%20of%20the%20actual%20spreadsheet%3F%20Just%20so%20long%20as%20it%20includes%20no%20confidential%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2258871%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20Populate%20Data%20based%20on%20Start%20%26amp%3B%20End%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2258871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3BI%20have%20attached%20it%20now.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

=IF(AND(K$2>=$G255,K$2<=$H255),$I255,"")

 

With the current formula above, I have to enter the "End Date" in order for it to populate. I would like for it populate when the End Date is blank, then once the End Date is entered it would true it up to that date.

 

CURTISSHORT_1-1617742169655.png

 

CURTISSHORT_0-1617742241510.png

 

5 Replies

@CURTISSHORT 

 

May I suggest that you attach not an image but a copy of the actual spreadsheet? Just so long as it includes no confidential information.

@mathetes I have attached it now. Thank you.

@CURTISSHORT 

I recognized nothing on the screenshot, in general that could be like

=IF(EndDate="", "", EndDate - StartDate)

 

I have attached the file now to the post...sorry I thought I had.
First off, thank you both for taking a look at my formula and sheet. I believe I have figured out my formula. I basically add an IF AND to reflect when the end date is blank to populate across the sheet. Once the end date is entered, it trues up the cost to the end date of the item or equipment.

=IF(AND(K$2>=$G255,K$2<=$H255),$I255, IF(AND(K$2>=$G255, $H255=""),$I255,""))