31st

Hi ya, I need to write dates in following format in excel. 31-04-2075, Excel automatically reads it as 31st April 2075 and makes it invalid as Georgian calendar does not have 31st April ever. But, what I am trying to write is 31st day of fourth month of 2075th year. That's the calendar...

Hi guys. I am trying to count my expenditures using excel. (I know, I am probably developing a wheel again). I have met difficulties, when realized, that the date "31st January" may have not one but plenty different types of expenditures. So I cannot use one row for the 31st January, but have...

Hi, I have seen many articles or posts on the internet that using the following formula, I could get the first workday of the month. =WORKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1,1) However, the result of the formula is 43040. It doesn't make sense to me. Do I need to convert it first...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I need to calculate the interest paid out as on today for a large number of Lump sum Term Deposits. Interests on the deposits are paid every calendar quarter...

Hi I have a table in Excel that goes up to 20,000 rows. The range is $A$2:$O$20000. The table is in a tab where new data is added on a monthly basis. The new data is taken from a report where the original report covered 1st March 2015 to 31st July 2017. When new data is added, the end...