Convert number of days into date

[WSTE]

Hello All,
I'm stuck in this & need the help that i can get. I have this excel sheet in which i have data for Booking that i have done & for the same i keep a cancellation date which i keep for 40 days from eg: today's date is 10th Jan'18 & if i calculate 40days would be 19th Feb'18 which it should display. default is 40days. A another eg: i did a booking today 10th Jan'18 & the cancellation i'll keep as 20th March'18 but it should in CELL A should display me what would be the 40th day (DATE). If anyone can please help me on this. Thank You

[AliGW]

Welcome to the forum!

In the cell where you want to display the date that is 40 days on:

=A1+40

where A1 contains the booking date.

Format your cell as a date.

[WSTE]

Wow! It just worked. Thank you so much. If its ok one more thing, with the above formula i'm getting the date on the 40th day now here i placing another formula in B1 in which i'm calculating Cancellation Date - Booking Date = For No. of Days. In C1 the formula that i want is No. of days Past 40Days. which is B1-40 = answer, but here along with the Value if i need to display the word Days along. How to do it?? Please.

[WSTE]

Wow! It just worked. Thank you so much. If its ok one more thing, with the above formula i'm getting the date on the 40th day now here i placing another formula in B1 in which i'm calculating Cancellation Date - Booking Date = For No. of Days. In C1 the formula that i want is No. of days Past 40Days. which is B1-40 = answer, but here along with the Value if i need to display the word Days along. How to do it?? Please.

[AliGW]

Try:

=DATEDIF(A1,B1)&" Days"

[WSTE]

its giving error message for the above formula like =DATEDIF(A1,B1)&"DAYS".
eg: The booking was done on 10-Jan-18, the cancellation is on 15-Mar-18 so it is 64days so minus it with 40days its 24. here if i'm using the formula 64-40=24 using it as =(C1-40)&"DAYS" it is like giving this green tag on top left of the cell stating something is not right in the formula? How can i write the formula where it would get this 24 Days??

[AliGW]

You will need to attach the workbook.

[WSTE]

Please find the attached file for your reference. I needed DAYS to be displayed after the number that's CELL J

[WSTE]

Hello were you able to find the solution for the problem??

[daddylonglegs]

Two ways to do this

You can change the formula in J3 to the following

=H3-40&" days"

....OR....

leave the formula as it is and just custom format cell as

0" days";;

The latter is better if you want to use column J for further calculations, because the underlying cell value is still a number