0 votes

I should change the structure of the days to "—Years—Months—Days." Most of my calculations involve working day percentages.

```=DATEDIF(B2,C2,"y")&" years "&DATEDIF(B2,C2,"ym")&" months "&DATEDIF(B2,C2,"md")&" days"
```

is effective for date-to-date. I need the day counts in this case. in the format "—Years—Months—Days."

like: 10 September 2021 to 1 March 2023 (546 days) 75% of 546 is 409.5 I have to figure out how many years, months, and days there are in 409.5. Can it be done?

Jan 30, 2023 in Others 412 views

## 1 answer to this question.

0 votes

Try,

`=DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") & " Months, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"MD") & " Days"`
answered Jan 30, 2023 by
• 63,720 points

–2 votes
0 answers

## Company will be able to quickly issue SIM to user and expected gain in volume is approximately 10 times as the manual process of verification is replaced with secure automated system

LifeTel Telecom is the latest entrant in the ...READ MORE

0 votes
1 answer

## Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

0 votes
0 answers

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

+1 vote
1 answer

## How To Create Phone Number Format XXX-XXX-XXXX In Android

can try: private String formatNumbersAsCode(CharSequence s) { ...READ MORE

0 votes
1 answer

## Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

0 votes
1 answer

## Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

0 votes
1 answer

## Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

0 votes
1 answer

## Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

0 votes
1 answer

## How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

0 votes
1 answer

## Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE