excel formula need

R

ravindra1962

New Member
Joined
Jan 21, 2017
Messages
19
Office Version
  1. 2007
Platform
  1. Windows
MONTH OPTEDFromtoBasic Pay
Nov-19​
01-07-201931-07-2019
51230​
01-08-2019​
31-08-2019
51230​
01-09-201930-09-2019
51230​
01-10-2019​
31-10-2019
51230​
01-11-2019​
30-11-2019
52590​
01-12-2019​
31-12-2019
52590​
01-01-2020​
31-01-2020
52590​
01-02-2020​
29-02-2020
52590​
01-03-2020​
31-03-2020
52590​
01-04-2020​
30-04-2020
52590​
IF I HAVE OPTED FOR NOVEMBER 2019
FROMTOTOTAL
MONTHS		BASIC PAY
01.07.201931.10.20194 MONTHS
51230​
01.11.201930.04.20196 MONTHS
52590​
I NEED FORMULA IN EXCEL IN THE ABOVE COLUMNS PLEASE
 
Sort by date Sort by votes
Where does it show that?

If you use Formulas, Evaluate Formula then the steps should look like this:
1640658777308.png
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
You must log in or register to reply here.

Similar threads

J
  • Solved
Excel Formula to highlight most recent record
Replies
3
Views
99
etaf
etaf
V
  • Solved
Formula to calculate automatically progressive average
Replies
5
Views
200
etaf
etaf
M
  • Question
How to filter/lookup rows of data based on the latest date in a cell
Replies
8
Views
893
Peter_SSs
Peter_SSs
M
  • Solved
Formula Help.
Replies
3
Views
61
Fluff
Fluff
M
  • Question
Best solution to consolidate values that occur on multiple dates/lines
Replies
5
Views
269
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,992
Messages
6,122,631
Members
449,095
Latest member
bsb1122

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top