- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - wildcard characters "?" and "*"
- Advanced vlookup - Text vs. Number
- Copy data from strictly-protected sheet
- 2D SUMIF with two variables – one on column and one on row
- Show number in thousand (k) or in million (M) by using custom format
- SUM vs. SUBTOTAL
Tag Archives: DATEDIF
如何計算兩個日子之間有多少年／月／日？ Recently, I got enquired about function for calculating number of days from one date to another date. DATEDIF is on the top of my mind. ：） Interestingly this function is not commonly known probably because it won’t show up … Continue reading