https://technologyadvice.com/blog/marketing/excel-tricks-perform-basic-math-functions-without-creating-a-formula/ We're On IT. Tue, 15 Nov 2022 18:07:56 +0000 hourly 1 https://technologyadvice.com/blog/marketing/excel-tricks-perform-basic-math-functions-without-creating-a-formula/#comment-1597 Fri, 14 Feb 2014 22:38:02 +0000 https://technologyadvice.com/?p=4582#comment-1597 If you want to add 1 in previous date then you have to first type today() function or you can also type any date in cell A1 then you have to type this formula in next cell =A1+1 then press enter now drag it till target cell address… you will get result like 11/20/2013, 11/21/2013,11/22/2013 ……. and so on… If you have any other query regarding excel you have to logon http://www.eknowledges.com/ this site and submit your query in comment box of any post. Thanks.

]]> https://technologyadvice.com/blog/marketing/excel-tricks-perform-basic-math-functions-without-creating-a-formula/#comment-1598 Fri, 14 Feb 2014 22:38:00 +0000 https://technologyadvice.com/?p=4582#comment-1598 Just tired this with dates, seems to work though you need to change the cell format. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. This however changed the dates to numerical values, so you will need to change the format back to date.

]]> https://technologyadvice.com/blog/marketing/excel-tricks-perform-basic-math-functions-without-creating-a-formula/#comment-735 Wed, 20 Nov 2013 11:36:38 +0000 https://technologyadvice.com/?p=4582#comment-735 Brnfnk
Hi Brnfnk,
If you want to add 1 in previous date then you have to first type today() function or you can also type any date in cell A1 then you have to type this formula in next cell =A1+1 then press enter now drag it till target cell address… you will get result like 11/20/2013, 11/21/2013,11/22/2013 ……. and so on… If you have any other query regarding excel you have to logon http://www.eknowledges.com/ this site and submit your query in comment box of any post. Thanks.

]]> https://technologyadvice.com/blog/marketing/excel-tricks-perform-basic-math-functions-without-creating-a-formula/#comment-512 Fri, 13 Sep 2013 14:32:00 +0000 https://technologyadvice.com/?p=4582#comment-512 Just tired this with dates, seems to work though you need to change the cell format. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. This however changed the dates to numerical values, so you will need to change the format back to date.

]]>