How to calculate Date in Excel or create Date Formula

Hi

This blog explores certain features which I used in my daily routine work might be useful to you all.

I uses normally excel sheet as my internal database of all the activities or daily routine like taking care of expenses etc.


e.g many times we need to add/subtract dates to a particular date say for e.g
i bought a tv which is getting expired in 30days so to calculate the end date i can have something like this

Now since we know that intial date is 31 july 2011 and we need  to calculate expiry date which is after say 30 days we choose the B2 box and goto Fx line  as shown

Thus we can see the formula is added by addition of 30 days to the A2 box values which is our intial date

Thus it calculate automatically 30 days to our intial date.


Above is a very simple example to know how to calculate dates in Excel sheet with formula so if we know the intial date we can create a formulate for calculating upcoming date in excel as shown in above steps easily

We explore more soon.