calculating dates

Ozzie Bleeder

New Member
Joined
Feb 21, 2005
Messages
2
I need to be able to count down from a date to an expiry date, for example on logging on I wish to now how long before the expiry date. Can I then use Excel to report or flag dates within a 7 day period?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Ozzie Bleeder

New Member
Joined
Feb 21, 2005
Messages
2
Calulating Dates

To help you further here is an example of what I am trying to do.

My motor vehicle license is due for renewal on 22/02/2007 I last paid my dues on the 22/02/2004. How can excel tell me the number of days before my license expirys?

Is there a formula to flag this item xdays before it expiries?
 

Brianyo

Board Regular
Joined
Feb 21, 2005
Messages
91
Cell A1 = 22/07/2007 Cell B1 = 22/07/2004 Cell C1= A1-B1 This will give the number of days before the bill falls due you can then filter on Column C or no doubt someone on here can write some code for you
 

2rrs

Active Member
Joined
Dec 25, 2002
Messages
346
=IF(date-TODAY()<=30,"Due","")

this will give 30 days notice
 

Watch MrExcel Video

Forum statistics

Threads
1,123,481
Messages
5,601,918
Members
414,482
Latest member
morkar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top