[10000印刷√] excel subtract today from date 157385-Excel formula subtract today from date
Microsoft MVP (Excel) Alan B wrote in message news Does anyone know how to subtract from or add to the year in a given date eg if today's date is 28 Sep 07 I would like to be able to add 1 and subtract 1 to the year only giving 28 Sep 06 and 28 Sep 08 If I do minus 365 it will work, but not on leap year dates Thanks AlanThat happens if the result is a negative number Excel dates must be zero or greater Excel dates cannot be negative numbers In this example, the formula cell shows all number signs if you subtract the later date (B4) from the earlier date () The result is a negative number, and Excel cannot display the result Get the Current Date ToTODAY in Excel Today function in excel is the simplest type of function, which just returns today's date in the Month, Date, Year sequence of MMDDYYYY format It can be on any day of the year, and if we are using the Today function, it will only return the date on which we are performing the Today function in excel Today Formula In Exc...