countdown from a date

%3CLINGO-SUB%20id%3D%22lingo-sub-1768312%22%20slang%3D%22en-US%22%3Ecountdown%20from%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768312%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20not%20familiar%20with%20Excel%20jargon%2C%20so%20I'm%20having%20a%20hard%20time%20knowing%20how%20to%20ask%20what%20I%20need%20my%20spreadsheet%20today.%26nbsp%3B%20This%20is%20what%20I%20need%20it%20to%20do%3A%20When%20someone%20admits%20to%20the%20facility%20I%20work%20at%2C%20some%20have%20100%20days%20of%20Medicare%20to%20use.%26nbsp%3B%20I%20want%20their%20admission%20date%20to%20%3D%20100.%26nbsp%3B%20Then%20whatever%20the%20current%20days%20is%2C%20I%20would%20like%20the%20days%20left%20to%20subtract%20from%20the%20admission%20date.%26nbsp%3B%20So%20if%20I%20admit%20on%2010%2F1%20and%20have%20100%20days%2C%20then%20today%20is%2010%2F3%2C%20that%20would%20mean%20I%20have%2098%20days%20left.%26nbsp%3B%20How%20do%20I%20make%20this%20happen%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1768312%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1768329%22%20slang%3D%22en-US%22%3ERe%3A%20countdown%20from%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827731%22%20target%3D%22_blank%22%3E%40bterning%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20treats%20dates%20as%20integers%2C%20so%20you%20can%20just%20subtract%20them.%20Assuming%20admit%20date%2C%2010%2F1%2F20%2C%20is%20in%20A2%2C%20then%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday()-A2%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewould%20give%20you%202%20days.%20But%2C%20since%20Medicare%20counts%20the%20day%20of%20admission%20and%20not%20the%20day%20of%20discharge%2C%20then%20I%20would%20think%20you%20would%20also%20want%20to%20test%20if%20Today%3DAdmit%20Date%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D100-(TODAY()-A2%2B(TODAY()%3DA2))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1768358%22%20slang%3D%22en-US%22%3ERe%3A%20countdown%20from%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1768358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%26nbsp%3B%20It%20worked!%26nbsp%3B%20I%20want%20to%20learn%20more%20of%20this%20to%20make%20my%20work%20more%20efficient.%26nbsp%3B%20This%20is%20a%20game%20changer!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am not familiar with Excel jargon, so I'm having a hard time knowing how to ask what I need my spreadsheet today.  This is what I need it to do: When someone admits to the facility I work at, some have 100 days of Medicare to use.  I want their admission date to = 100.  Then whatever the current days is, I would like the days left to subtract from the admission date.  So if I admit on 10/1 and have 100 days, then today is 10/3, that would mean I have 98 days left.  How do I make this happen?

3 Replies
Highlighted

@bterning 

 

Excel treats dates as integers, so you can just subtract them. Assuming admit date, 10/1/20, is in A2, then

 

Today()-A2  

 

would give you 2 days (if today were 10/3/20). But, since Medicare counts the day of admission and not the day of discharge, then I would think you would also want to test if Today=Admit Date:

 

=100-(TODAY()-A2+(TODAY()=A2))

 

Highlighted

@JMB17 

 

Thank you so much!  It worked!  I want to learn more of this to make my work more efficient.  This is a game changer!

Highlighted
Since you are fairly new, I should point out that this part:

(TODAY()=A2)

Works the same as this:
IF(TODAY()=A2,1,0)

For Excel TRUE=1 and FALSE=0, so I'm using a small shortcut.