Calculating days since a particular event
Is there a way to automatically calculate days since a particular date
(event)? For example, if X event (in column A) happened on 1/1/06 and Y event (in column B) happened on 10/14/07, how do I make column C = the number of days between X and Y (column A and B)? Thanks |
Calculating days since a particular event
Hi,
As long as you are using Dates ... =B2-A2 HTH |
Calculating days since a particular event
=B1-A1
format as general -- Regards, Peo Sjoblom wrote in message ... Is there a way to automatically calculate days since a particular date (event)? For example, if X event (in column A) happened on 1/1/06 and Y event (in column B) happened on 10/14/07, how do I make column C = the number of days between X and Y (column A and B)? Thanks |
Calculating days since a particular event
if column A and B are both formatted as dates:
=B2-A2 Format the result cell (C2) as General or Number. Dates are actually stored as numbers that are incremented by 1 for each day, so subtracting one date from another will always give you a number of days. " wrote: Is there a way to automatically calculate days since a particular date (event)? For example, if X event (in column A) happened on 1/1/06 and Y event (in column B) happened on 10/14/07, how do I make column C = the number of days between X and Y (column A and B)? Thanks |
All times are GMT +1. The time now is 03:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com