Help me

%3CLINGO-SUB%20id%3D%22lingo-sub-3012864%22%20slang%3D%22en-US%22%3EHelp%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3012864%22%20slang%3D%22en-US%22%3EHi%20everyone%3CBR%20%2F%3EI%20need%20help%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20start%20date%20and%20end%20date%2C%20I%20want%20calculate%20how%20many%20months%20left%20or%20days%20%3F%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20can%20you%20help%20me%20which%20functions%20can%20I%20used%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3012864%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-3013044%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231974%22%20target%3D%22_blank%22%3E%40faalmutawa%3C%2FA%3E%26nbsp%3BLet's%20say%20the%20start%20date%20is%20in%20A1%20and%20the%20end%20date%20in%20A2.%20Enter%20the%20following%20formula%20in%20any%20empty%20cell%2C%20to%20calculate%20the%20number%20of%20days%20between%20these%20two%20dates%3A%3C%2FP%3E%3CP%3E%3DA2-A1%2B1%3C%2FP%3E%3CP%3EFormat%20the%20cell%20with%20this%20formula%20as%20%22General%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20calculate%20the%20number%20of%20days%20to%20go%20from%20today's%20date%20until%20the%20end%2C%20use%20this%20one%3A%3C%2FP%3E%3CP%3E%3DA2-TODAY()%2B1%3C%2FP%3E%3CP%3EFormat%20the%20cell%20with%20this%20formula%20as%20%22General%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDivide%20the%20number%20by%2030%20and%20you%20roughly%20end-up%20with%20the%20number%20of%20months.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi everyone
I need help


I have start date and end date, I want calculate how many months left or days ?

So can you help me which functions can I used
2 Replies

@faalmutawa Let's say the start date is in A1 and the end date in A2. Enter the following formula in any empty cell, to calculate the number of days between these two dates:

=A2-A1+1

Format the cell with this formula as "General".

 

If you want to calculate the number of days to go from today's date until the end, use this one:

=A2-TODAY()+1

Format the cell with this formula as "General".

 

Divide the number by 30 and you roughly end-up with the number of months.

@faalmutawa 

Another option is the DATEDIF function

"Months"
= DATEDIF(start,end,"m")
"plus days"
= DATEDIF(start,end,"md")

QUOTIENT and MOD would provide similar values from @Riny_van_Eekelen's count of days.