Turn a number into a date from today

[jimjam]

OK so I have a long list of drugs and the frequency and number they are taken during the day.

This give me a daily total used per drug

I divide the total number of each type of tablets in my possession by the number needed per day

I then have the number of days each drug will last

Question. How can I get a date that the tabs will run out. For example my sheet might say I have 45 days supply. How can I turn that 45 into a date that we will run out of drugs. Thanks

[jeffreybrown]

You can simply add 45 to a date. A date is nothing but a number.

Today's date >> 16-Jan-17 equals 42751

45 + 42751 = 42751 >> equals 2-Mar-17

http://www.cpearson.com/excel/datetime.htm